Your question is Find Third Highest Salary in SQL. 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.
Arcesium's compensation analytics team needs to identify the third-highest distinct salary in an employee dataset. Write a PostgreSQL query that returns exactly one salary value.
NULL.Use only the employees table. Do not return employee details or calculate the result procedurally.
| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's name |
| salary | NUMERIC(12,2) | Annual salary in USD |