apl-mhd

employee manager relationship

Dec 24th, 2018
152
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT e1.EMPLOYEE_ID, e1.FIRST_NAME, e1.MANAGER_ID, e2.FIRST_NAME  FROM employees e1
  2. JOIN employees e2
  3. WHERE e1.MANAGER_ID = e2.EMPLOYEE_ID
RAW Paste Data