← Interviews
QUESTION
The second highest salary
+50 XP
Professor Owl
The second highest salary
A classic first-round question: sorting isn't enough, you have to think about what happens with the maximum.
Goal
Return the second highest salary in the employees table (a single row and a single column).
Key facts
- Tables: employees, customers, orders
- Difficulty: Easy
⏳ Preparing data…
What the database returns
Run your query and the rows will appear here.
🎯 You solve it when your query returns exactly what the goal asks for.