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 vote247 views3 answers
Characters found after end of sql statement
SQL
1 vote181 views1 answer
Partition by sql server
SQL
14 votes1.2K views1 answer
Sql value of string
SQL
0 vote274 views1 answer
Mysql get nested records
SQL
0 vote188 views1 answer
Sql select column names starting with
SQL
0 vote177 views1 answer
Close sql query vb.net
SQL
0 vote227 views1 answer
Plsql check for string in numeric
SQL
0 vote213 views1 answer
Plpgsql if statement
SQL
10 votes212 views6 answers
Sql between
SQL
0 vote187 views1 answer
Sql server select value large text
SQL