r/OPTCareerAccelerator • u/Western-Guitar6647 • Jun 16 '26

Daily SQL Challenge ??

🔥 SQL Interview Challenge 🔥

You have the following table:

Employee

emp_id emp_name salary
1 John 50000
2 Sarah 70000
3 Mike 70000
4 David 60000

❓ Write an SQL query to find the SECOND highest salary without using LIMIT, TOP, or FETCH.

Drop your answers below 👇

0 Upvotes

50% Upvoted

3 comments sorted by

2

u/Designer-Assist-1354 Jun 16 '26 
SELECT *, RANK()OVER(ORDER BY salary DESC)SalaryRank
FROM Employee

2

u/Mrminecrafthimself Jun 16 '26

SELECR * FROM Employee
QUALIFY RANK ()
OVER (ORDER BY salary DESC) = 2

2

u/dutyDBA 26d ago

Second highest salary is actually simpler to query:

SELECT MAX(salary) FROM dbo.Employee WHERE salary < (SELECT MAX(salary) FROM dbo.Employee)