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

7 votes129 views4 answers
What is my mysql version
SQL
0 vote95 views2 answers
Jupyter notebook connect to database
SQL
0 vote136 views1 answer
Get role postgres
SQL
2 votes126 views1 answer
Get first 3 letters name in sql
SQL
0 vote165 views3 answers
Get count of null in column sql
SQL
0 vote136 views1 answer
Sql drop default
SQL
3 votes139 views3 answers
Stop mysql ubuntu
SQL
29 votes126 views6 answers
Delete all rows from table mysql
SQL
1 vote122 views1 answer
Stop mysql server mac
SQL
20 votes126 views5 answers
Sql show tables
SQL