1. Get Second Maximum Salary In mysql.
SELECT * FROM `employee` WHERE salary = ( SELECT MAX( salary ) FROM employee WHERE salary < (SELECT MAX(salary) FROM employee)
0
1. Get Second Maximum Salary In mysql.
SELECT * FROM `employee` WHERE salary = ( SELECT MAX( salary ) FROM employee WHERE salary < (SELECT MAX(salary) FROM employee)
0