employee and salary table find 2nd highest salary code example
Example: Find the Second Highest salary of an employee from an employee table
SELECT name, MAX(salary) AS salary
FROM employee
WHERE salary < (SELECT MAX(salary)
FROM employee);