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 vote131 views1 answer
Mysql_num_fields in mysqli
SQL
3 votes130 views1 answer
Oracle transaction commit rollback example
SQL
1 vote134 views1 answer
Sql select table header
SQL
0 vote130 views1 answer
Set open file limit mac catalina mysql
SQL
5 votes122 views4 answers
Describe table postgres
SQL
3 votes115 views1 answer
MySQL DELETE JOIN
SQL
0 vote149 views1 answer
Including parameters in OPENQUERY
SQL
12 votes134 views5 answers
Rename table in mysql
SQL
0 vote154 views1 answer
Mysql export data with a where clause
SQL
1 vote136 views2 answers
Mysql remove first and last character from string
SQL