Answers for "write an sql query that returns a table comprising all the departments in the table department that hire at least one employee"

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

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

Posted by: Guest on January-28-2021

Code answers related to "write an sql query that returns a table comprising all the departments in the table department that hire at least one employee"