Where

•Restrict the rows that are returned by using the WHERE clause
•To filter condition and to select specified data

Select employee_id, last_name, job_id, department_id
From employees
Where department_id = 90;

Operator	Meaning
=	Equal to
>	Greater than
>=	Granter than or equal to
<	Less than
<=	Less than or equal to
<>	Not equal to
Between …and…	Between two values
In	Match any of a list of values
Like	Match a character pattern
Is null	Is a null value

Select last_name, salary, job_id
From employees
where salary > 10000
Or job_id like '%man';




Select last_name, salary
From employees
Where salary between 2500 and 3500;




Select employee_id, last_name, salary, manager_id
From employees
Where manager_id in (100, 101, 201);