Sunday, December 21, 2014

SQL basics - ( SELECT - WHERE - NULL| AND/OR| NOT) - (For absolute beginners) - Tutorial 7

****************USING THE NULL CONDITIONS*********************
SELECT last_name,manager_id FROM employees WHERE manager_id IS NULL;


****************USING THE AND OPERATOR*********************
SELECT employee_id,last_name,job_id,salary FROM employees
 WHERE salary >= 10000 AND job_id LIKE '%MAN%';


****************USING THE OR OPERATOR*********************
SELECT employee_id,last_name,job_id,salary FROM employees
 WHERE salary >= 10000 OR job_id LIKE '%MAN%';


****************USING THE NOT OPERATOR*********************
SELECT last_name,job_id FROM employees 
WHERE job_id NOT IN ('IT_PROG','ST_CLERK','SA_REP');

No comments:

Post a Comment

Constructor Chaining