Return top values including ties

WITH ranked AS (
  SELECT employee_id,
         department_id,
         salary,
         RANK() OVER (
           PARTITION BY department_id
           ORDER BY salary DESC
         ) AS rnk
  FROM employees
)
SELECT *
FROM ranked
WHERE rnk <= 3;