Your question is Second Highest Salary at NovaTech. 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.
NovaTech wants a quick salary check from its employee records. Write a SQL query to return the second highest distinct salary from the employees table.
second_highest_salaryNULL| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee full name |
| department | VARCHAR(50) | Employee department |
| salary | INT | Employee salary amount |