Using the IN Condition

Use the IN membership condition to test for values in a list:

SELECT employee_id, last_name, salary, manager_id

FROM   employees

WHERE  manager_id IN (100, 101, 201) ;

EMPLOYEE_ID	LAST_NAME	SALARY	MANAGER_ID
201	Edi	1000	100
202	Laki	2000	100
203	John	1500	101
204	Haan	3000	201