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 vote150 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote149 views1 answer
Sql value exists in column
SQL
0 vote141 views1 answer
Mariadb current date plus 1 day
SQL
0 vote145 views1 answer
Mysql sleep connections
SQL
6 votes149 views1 answer
Postgresql add enum value
SQL
0 vote168 views1 answer
Testing sql queries
SQL
2 votes143 views1 answer
Update trigger
SQL
0 vote143 views1 answer
Inserted row count tsql
SQL
0 vote144 views3 answers
Mysql delete if not in another table
SQL
1 vote177 views2 answers
Intersect sql
SQL