Your question is SQL Query for Second Highest. 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.
Iris software wants a quick compensation report showing the second-highest salary currently recorded in its employee table. Write a PostgreSQL query that returns the second-highest distinct non-null salary.
NULL.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's name |
| salary | NUMERIC(12,2) | Annual employee salary |