To find max second salary without using sub-query
By using sub-query, get all second salary records
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