programming-examples/Write a query to get the details of employees who manage a department.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

7 lines

193 B

SQL

Raw Permalink Blame History

 /*Write a query to get the details of employees who manage a department.
 */
     SELECT *
     FROM employees
     WHERE employee_id=ANY
     ( SELECT manager_id FROM departments );