Top N Earners Per Department
Write a SQL query to find the top 3 highest-paid employees in each department. Return `department`, `employee_name`, and `salary` columns, ordered by department and salary descending.
Use the `employees` table with columns: `id`, `name`, `department`, `salary`.
Examples
Example 1
Input: employees table with 20 rows
Output: 3 rows per department, highest salaries first
solution.py
1
2
3
4
5
6