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 vote313 views1 answer
Selecting from a view SQL
SQL
0 vote324 views1 answer
T sql dynamic top n query
SQL
0 vote314 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote312 views1 answer
Convert rows to columns in sql server
SQL
0 vote292 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote318 views1 answer
Helptext in sql
SQL
0 vote336 views1 answer
Prisma transaction
SQL
36 votes317 views6 answers
Rename table sql
SQL
0 vote347 views1 answer
Oracle pl/sql check if file exists
SQL
3 votes306 views2 answers
Host is not allowed to connect to this mysql server
SQL