find the Second Highest Salary of Employee in SQL
SELECT MAX(salary) FROM employee WHERE salary NOT IN (SELECT MAX(salary) FROM employee); ======================================================================= OR ======================================================================= select salary from employee order by salary desc limit 1 offset 1 ===============================================================