Your question is Second Largest 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.
Afiniti needs a simple salary audit for employees supporting its AI-powered customer interaction platform. Write a PostgreSQL query to find the second-highest distinct salary in the employee directory.
NULL.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's name |
| department | VARCHAR(50) | Employee's department |
| salary | NUMERIC(10,2) | Annual salary |