query to find highest salary of employee 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);