How to get 2nd highest salary from db

Question

To find highest salary from db we use max in query.

How to get 2nd highest salary from db. can any one suggest the sq query

did you try to google it? there are plenty of results for [sql select second highest value](http://stackoverflow.com/questions/32100/what-is-the-simplest-sql-query-to-find-the-second-largest-value) — SomeJavaGuy, Aug 19 '15 at 14:44

score 1 · Accepted Answer · answered Aug 19 '15 at 14:46

1

This should help:

SELECT max(salary) 
FROM mytable
WHERE salary < (
   SELECT max(salary) FROM mytable
)

answered Aug 19 '15 at 14:46

Jacobian

Matt · Answer 2 · 2015-08-19T15:21:40.970

1

Far to many ways to achieve this.

SELECT Salary 
FROM Salarytable 
ORDER BY Salary DESC
LIMIT 1,1

edited Aug 19 '15 at 15:21

answered Aug 19 '15 at 14:46

Matt

I guess, you are ordering not by the right field. It will probably work only, if lower SalaryID means higher salary. – Jacobian Aug 19 '15 at 14:50
@Jacobian Whoops, My bad was meant to just say salary! – Matt Aug 19 '15 at 15:22

2 Answers2