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

1 vote314 views1 answer
Sqlite check if row exists
SQL
6 votes323 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote327 views1 answer
Increasing font and zooming in mysql workbench
SQL
4 votes294 views1 answer
Update table from another table oracle
SQL
0 vote348 views1 answer
For select oracle
SQL
1 vote326 views4 answers
Aggregate function in sql
SQL
0 vote265 views1 answer
Oracle function select into
SQL
2 votes292 views1 answer
Mysql add boolean column
SQL
0 vote326 views1 answer
Ms sql print more than 1 variable
SQL
1 vote313 views1 answer
Mysql current running queries
SQL