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

0 vote125 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote109 views2 answers
Select limit ms sql
SQL
3 votes167 views2 answers
How to View column names of a table in SQL
SQL
1 vote134 views1 answer
Sql row having max
SQL
0 vote136 views1 answer
Oracle pl/sql check if file exists
SQL
3 votes121 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote148 views1 answer
Homebrew install mysql
SQL
0 vote117 views1 answer
Check if table exists oracle
SQL
0 vote125 views1 answer
Delete ids between sql
SQL
28 votes121 views4 answers
Mysql delete database
SQL