Your question is Nth Salary 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.
Write a SQL query to find the nth salary.
Treat salaries as distinct values, ignore NULL salaries, and use n = 3 for this exercise.
nth_salary.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee name |
| department | VARCHAR(80) | Employee department |
| salary | NUMERIC(12,2) | Annual employee salary |