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 vote133 views2 answers
Laravel jwt generate token
SQL
0 vote121 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
11 votes126 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote112 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote121 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote122 views1 answer
MySQL get all previous date record
SQL
1 vote110 views1 answer
Index a database column sql
SQL
3 votes119 views1 answer
Oracle revoke grant
SQL
0 vote115 views1 answer
Pip install mysqlclient error
SQL
0 vote124 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL