Your finance team wants a quick snapshot of the highest earners before comp-review season. Using the employees table, return the name and salary of the 5 highest-paid employees, ordered by salary descending.
employees
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| department | TEXT |
| salary | NUMERIC |
| id | name | department | salary |
|---|---|---|---|
| 1 | Alice | Engineering | 120000 |
| 2 | Bob | Marketing | 85000 |
| 3 | Carol | Engineering | 135000 |
| 4 | Dave | HR | 72000 |
| 5 | Eve | Engineering | 115000 |
| 6 | Frank | Marketing | 90000 |
| 7 | Grace | HR | 68000 |
| 8 | Heidi | Engineering | 140000 |
| name | salary |
|---|---|
| Heidi | 140000 |
| Carol | 135000 |
| Alice | 120000 |
| Eve | 115000 |
| Frank | 90000 |
Employees are ranked by salary descending. The top 5 are Heidi, Carol, Alice, Eve, and Frank. Bob (85000), Dave (72000), and Grace (68000) are excluded by the LIMIT 5.