Your question is Second-Highest Salary Without LIMIT. 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.
Persistent Systems wants to identify the second-highest distinct salary in its engineering workforce. Write a PostgreSQL query using the employees table, without using the LIMIT keyword.
second_highest_salary.NULL if there is no salary below the maximum salary.LIMIT.| Column | Type | Description |
|---|---|---|
| employee_idPK | INTEGER | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| department | VARCHAR(80) | Employee's department |
| salary | NUMERIC(10,2) | Annual salary |