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

2 votes203 views2 answers
Postgres select duplicate columns
SQL
0 vote195 views2 answers
Mysql select date from datetime
SQL
0 vote182 views1 answer
Import mysql'
SQL
0 vote197 views1 answer
Running percentage of total postgres
SQL
0 vote214 views1 answer
Mysql edit trigger
SQL
3 votes224 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote196 views1 answer
Postgresql escape single quote
SQL
0 vote180 views1 answer
Bash block size ls /var/lib/mysql
SQL
-1 vote196 views3 answers
Psql get last rows
SQL
5 votes192 views1 answer
Postgresql functions
SQL