Your question is Top 3 Salaries SQL Query. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
PlayStation Network wants a simple compensation report showing its three highest-paid employees. Write a PostgreSQL query that retrieves the employee details for the highest salaries.
employee_id, employee_name, and salary for the three highest non-null salaries.employee_id as a secondary sort key for deterministic results when salaries are equal.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| salary | NUMERIC(12,2) | Annual salary in USD |