Mysql get nth highest

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  SET N = N-1;
  
  RETURN (
      # Where Salary is your column name and Employee your table
      SELECT DISTINCT(Salary) FROM Employee ORDER BY Salary DESC LIMIT N, 1
  );
END

Similar codes

28 votes103 views4 answers
Show tables mysql
SQL
0 vote111 views1 answer
Drop index in sql
SQL
1 vote103 views1 answer
Sql update table remove spaces
SQL
0 vote108 views1 answer
Sql query for getting data with join and count
SQL
5 votes159 views1 answer
Dbms_metadata.get_ddl table
SQL
4 votes102 views6 answers
Second max salary in sql
SQL
0 vote99 views1 answer
T-SQL Never ending DELETE
SQL
7 votes111 views2 answers
Get database size mysql
SQL
-1 vote102 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
1 vote94 views1 answer
"i_am_a_dummy flag" in MySQL
SQL