Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT( man.FIRST_NAME)
- FROM employees emp
- JOIN employees man on
- emp.MANAGER_ID = man.EMPLOYEE_ID
- SELECT FIRST_NAME
- FROM employees
- WHERE EMPLOYEE_ID in ( SELECT MANAGER_ID FROM employees)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement