Sunday, December 21, 2014

SQL basics - ( SELECT - WHERE - BETWEEN | IN | LIKE) - (For absolute beginners) - Tutorial 6


****************USING BETWEEN CONDITION*********************
SELECT last_name,salary FROM employees WHERE salary BETWEEN 2500 AND 3500;
 
****************USING THE IN CONDITION*********************
SELECT employee_id,last_name,salary,manager_id FROM employees WHERE manager_id
IN (100,101,201); 

****************USING THE LIKE CONDITION*********************
SELECT first_name FROM employees WHERE first_name LIKE 'S%';

SELECT last_name FROM employees WHERE last_name LIKE '_o%';

No comments:

Post a Comment

Constructor Chaining