Second highest salary in MYSQL?

By February 28, 2012 My SQL
MY SQL

We have one tables tblSalary

empID     empName   empSal
1              A                 5000
2              B                 3000
3              C                 2000
4              D                 6000

Using of limit option we can find second highest salary in mysql.

select empSal from tblSalary order by empSal DESC Limit 1, 1

Output

5000

Leave a Reply

64 − = 60