OPERATORS

COMPARISON OPERATORS

>,<,!=  are comparison operators.

for example to display e_ name,job,salary from table employee_668 where job is not manager.

SELECT E_NAME,JOB,SALARY FROM EMPLOYEE_668 WHERE JOB!=MANAGER;

LOGICAL OPERATORS

AND,OR are logical operators.

 for eg. to display e_name whose salary is less than 2000 and whose job is clerk.

SELECT E_NAME FROM EMPLOYEE_668 WHERE SALARY<2000 AND JOB=CLERK;

for eg, to display e_name whose salary is greater than 10000 or whose job is manager.

SELECT E_NAME FROM EMPLOYEE_668 WHERE SALARY>10000 OR JOB=MANAGER;

SPECIAL OPERATORS

BETWEEN,IN  are special operators.

for eg.to display e_name from employee_668 where salary is between2000 and 3000

SELECT E_NAME FROM EMPLOYEE_668 WHERE SALARY BETWEEN 2000 AND 3000;

for eg. list details of employee_668 who are not working in department number10,20,30,40,50.

SELECT*FROM WHERE DEPT NO IN(10,20,30,40,50);