What is a Clause?

By supplying a condition to the query, a SQL clause is constructed to limit the result set. This typically selects a few rows from the whole collection of records. A query with a WHERE condition is an example of a clause.

Example

Employee Table

emp_id emp_name salary dept_id manager_id
E1 Rahul 15000 D1 M1
E2 Manoj 15000 D1 M1
E3 James 55000 D2 M2
E4 Michael 25000 D2 M2
E5 Ali 20000 D10 M3
E6 Robin 35000 D10 M3

Query

The following query will return the name of all the employees with salaries greater than 20000.

SELECT emp_name FROM Employee
WHERE salary > 20000;

Output

emp_name
James
Michael
Robin