Advertisement
Guest User

Untitled

a guest
Jan 29th, 2020
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. WITH ct AS (

  2. SELECT 
*,

  3. ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS rn

  4. FROM employees

  5. )

  6. SELECT department, name, salary

  7. FROM ct
  8. 
WHERE rn <= 3
;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement