Find the second largest number Sql-second highest Salary

1: Find the largest maximum

Select Max (Salary) from the employee where salary< (select Max (Salary) from employee);

2. Sorting

Select  Salary from employee where Salary not in (select MAX (Salary) from employee) Order BY Salary desc LIMIT 1;

　　

Select (select DISTINCT Salary from Employee order by Salary Desc limit 1 offset 1) as secondheighestsalary;

　　

Find Nth Number:

CREATE FUNCTION getnthhighestsalary (N INT) RETURNS intbegindeclare M int;set n=n-1;  RETURN (           # Write your MySQL query statement below.      Select  Salary from Employee ORDER BY Salary desc LIMIT 1 offset N  ); END

　　

CREATE FUNCTION getnthhighestsalary (N INT) RETURNS intbegindeclare M int;set n=n-1;  RETURN (           # Write your MySQL query statement below.      Select  distinct Salary from Employee ORDER BY Salary desc LIMIT 1 offset N  ); END

You can't N-1 in limit, because the limit doesn't count.

Haha: distinct: May contain duplicate values in a table, return unique values,

Find the second largest number Sql-second highest Salary