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 select 2nd highest salary from MySQL table. Show all posts
Showing posts with label How to select 2nd highest salary from 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)