Tuesday, 4 October 2011

Find second max salary in MySQL

To find max second salary without using sub-query
SELECT salary FROM `salary_table` GROUP BY `salary` DESC LIMIT 1 , 1;

By using sub-query, get all second salary records
SELECT max(salary) FROM `salary_table` WHERE salary = (SELECT max(salary)FROM `salary_table`);

0 comments:

Post a Comment