Page 6 - Simple Queries in SQL

WHERE Clause

 Output based on condition
Select <col list>
from table
where <cond>

select ename, job
from employee
where deptno = 20;
Or
select ename, job
from employee
where job = 'CLERK' OR job = 'ANALYST';
Or
select ename, job
from employee
where NOT (job = 'CLERK' || job = 'ANALYST');

BETWEEN Clause

 BETWEEN clause
Select ename, hiredate
from employee
where sal BETWEEN 2000 AND 3000
(Note: BETWEEN includes both the lower and upper range)
Select ename, hiredate
from employee
where sal NOT BETWEEN 2000 AND 3000

IN Clause
Condition to select from a set/list – IN clause
select ename
from employee
where job IN ('CLERK', 'ANALYST', 'MANAGER');

OR

select * from employee
where job NOT IN ('CLERK', 'ANALYST', 'MANAGER');