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 vote281 views1 answer
Conda install pymysql "windows"
SQL
0 vote270 views1 answer
How to connect to mysql in ef 6
SQL
0 vote285 views1 answer
Query archive mode
SQL
0 vote298 views1 answer
Restore backup mysql .gz
SQL
1 vote289 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote302 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
17 votes315 views4 answers
Show tables sql server
SQL
0 vote314 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
5 votes341 views1 answer
Oracle ora-00054 find
SQL
1 vote303 views1 answer
Oracle insert multiple rows into same table
SQL