Advertisement
apl-mhd

print manager

Jul 15th, 2018
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.20 KB | None | 0 0
  1. SELECT DISTINCT( man.FIRST_NAME)
  2. FROM employees emp
  3. JOIN  employees man on
  4.  emp.MANAGER_ID = man.EMPLOYEE_ID
  5.  
  6.  
  7. SELECT FIRST_NAME
  8. FROM employees
  9. WHERE EMPLOYEE_ID in ( SELECT MANAGER_ID FROM employees)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement