0

Query for Second highest salary

Please help me in finding second highest salary without using subquery and top function

sql
20th Mar 2022, 3:23 PM
vivek B
vivek B - avatar
2 Answers
0
select salary from salaries order by salary desc offset 1 limit 1
22nd Mar 2022, 11:58 PM
Monica Garcia
Monica Garcia - avatar

Often have questions like this?

Learn more efficiently, for free:

See all courses
Hot today
Help
2 Votes
Ai now needs max?
3 Votes
Should I learn Kotlin?
1 Votes
КаĐș Ń€Đ”ŃˆĐžŃ‚ŃŒ?
0 Votes
is my code ok?
0 Votes
Code
2 Votes
Python multiprocessing module
0 Votes
I don't understand a thing💀
0 Votes
Course related help
0 Votes
PRO for students
0 Votes