Find the top 3 highest paid employees in each department.

Answer preview

Partition by department, rank salaries inside each partition with DENSE_RANK(), then keep the first three ranks — the canonical top-N-per-group pattern.…