Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT e.employee_id, e.last_name, d.department_name,
- COUNT(*) OVER (PARTITION BY E.MANAGER_ID)
- 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