Find the second highest salary from salary table in mysql
SELECT max(salary) FROM `employee` WHERE salary < (select max(salary) from employee )
Showing posts with label Get the second highest value in a MySQL table. Show all posts
Showing posts with label Get the second highest value in a MySQL table. Show all posts
Thursday 26 June 2014
Find the second highest salary from salary table in mysql
Find the second highest salary from salary table in mysql
SELECT max(salary) FROM `employee` WHERE salary < (select max(salary) from employee )
Subscribe to:
Posts (Atom)