Find the highest paid employee in each department, including ties.

Answer preview

Use RANK() partitioned by department and keep rank 1 — unlike ROW_NUMBER(), it returns every employee tied at the top.…