How to write a query to fetch third highest salary from table?
cid salary
--- ------
1 15000
2 20000
3 7000
4 35000
5 60000
Asked
Active
Viewed 140 times
0
Dharman
- 26,923
- 21
- 73
- 125
Himanshu Upadhyay
- 703
- 6
- 28
-
1select max( salary ) from yourtablename where salary < ( select max( salary ) from yourtablename ); – alagu Jul 24 '15 at 11:39
-
I got an answer.. select max(salary) from test where salary < (select max(salary) from test where salary < (select max(salary) from test)) – Himanshu Upadhyay Jul 24 '15 at 12:10
-
You got it. very good ;) – alagu Jul 24 '15 at 12:13