get all employees first name department id with department id of 100 in sql code example

Example 1: get all employees first name department id with department id of 100 in sql

SELECT FIRST_NAME , PHONE_NUMBER , DEPARTMENT_ID
FROM EMPLOYEES 
WHERE DEPARTMENT_ID IN (60,100,90,80,120)
;

Example 2: find out all employees with department id of 60 or 100 in sql

SELECT * FROM EMPLOYEES 
WHERE DEPARTMENT_ID = 60 OR DEPARTMENT_ID = 100 ;