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 vote260 views1 answer
How to move a columns location in mysql
SQL
0 vote240 views1 answer
Can't connect to postgresql mac os
SQL
2 votes261 views2 answers
Sql lag
SQL
1 vote239 views2 answers
T sql get foreign key
SQL
-1 vote252 views1 answer
Create view in mysql workbench
SQL
1 vote234 views1 answer
Change table to innodb mysql
SQL
0 vote229 views1 answer
Sqlite update only if greater
SQL
0 vote265 views1 answer
Mysql record group by created date count
SQL
0 vote243 views1 answer
Why we have to set the password for my sql server
SQL
2 votes220 views1 answer
Sql select min value from multiple columns
SQL