Write a query to find the top 3 unique salaries in each department and list all employees who have those salaries.

To find the top 3 unique salaries in each department and list employees with those salaries, you can use a window function like DENSE_RANK().

First, partition the employee table by department and assign a rank to each salary in descending order using DENSE_RANK(). This ensures that unique salaries get distinct ranks.

Then, select the employee's name, ID, salary, and department from this ranked result, filtering for rows where the rank is 3 or less. Finally, order the results by department and then by rank to present the top salaries and associated employees clearly within each department.