SQL Query Practice | Dataford Interview Questions

Write SQL to retrieve the second-highest salary from a table.

Return the second-highest distinct, non-null salary. If fewer than two distinct salary values exist, return no rows.

Output

employees

Your question is SQL Query Practice. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Write SQL to retrieve the second-highest salary from a table.

Return the second-highest distinct, non-null salary. If fewer than two distinct salary values exist, return no rows.

employees

Your question is SQL Query Practice. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.