Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. SELECT e.employee_id, e.last_name, d.department_name,
  2. COUNT(*) OVER (PARTITION BY E.MANAGER_ID)
  3. FROM employees e JOIN departments d ON E.EMPLOYEE_ID = D.MANAGER_ID ORDER BY D.DEPARTMENT_ID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement