Challenges/Top N Earners Per Department
Easy🗄️ sql

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