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 How to Find the second highest salary from table in mysql. Show all posts
Showing posts with label How to Find the second highest salary from table in mysql. 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)