programming-examples/Write a query to get the details of employees who are managers.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.

9 lines

214 B

SQL

Raw Permalink Blame History

 /*Write a query to get the details of employees who are managers.
 */
     SELECT *
     FROM employees
     WHERE EXISTS
     (SELECT *
     FROM departments
     WHERE manager_id = employee_id);