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%';