Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH ct AS (
- SELECT *,
- ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS rn
- FROM employees
- )
- SELECT department, name, salary
- FROM ct
- WHERE rn <= 3 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement