Answers for "Retrieve the employee_id, First_name, salary and department_name of all employees works in the following departments (20, 40, 70, 90)"

get all employees first name department id with department id of in sql

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

Posted by: Guest on January-28-2021

Code answers related to "Retrieve the employee_id, First_name, salary and department_name of all employees works in the following departments (20, 40, 70, 90)"