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 142 times
0
Dharman
- 30,962
- 25
- 85
- 135
Himanshu Upadhyay
- 723
- 7
- 30
-
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