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 vote205 views2 answers
Mysql cast to varchar
SQL
9 votes137 views2 answers
Get first 3 letters in sql
SQL
0 vote172 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote146 views1 answer
How to set all the min and sec data to zero in sql server
SQL
1 vote171 views3 answers
Postgresql get difference between two dates
SQL
5 votes183 views1 answer
How to use rank function in sql
SQL
2 votes198 views3 answers
Postgres create view
SQL
0 vote151 views1 answer
Sqlite higher or equal
SQL
0 vote146 views1 answer
Sql count * vs count 1
SQL
0 vote165 views3 answers
Insert query in ci
SQL