Your question is SQL Nth Highest Salary 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.
EXL Service Philippines uses salary analysis in its HR reporting workflows. Write a PostgreSQL query to return the third-highest distinct salary from the employee_salaries table.
NULL salaries before ranking salary levels.| Column | Type | Description |
|---|---|---|
| employee_idPK | INTEGER | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| salary | INTEGER | Annual salary in Philippine pesos |