Nth highest salary

Find nth highest salary of an employee

#Method 1
SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1

#Method 2
SELECT salary FROM Employee AS e1 
WHERE n-1=(SELECT COUNT(DISTINCT,salary) FROM Employee AS e2 
           WHERE e2.salary>e1.salary)

Nth highest salary

SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1

Source: javarevisited.blogspot.com

3rd height salary sql

SELECT MIN(EmpSalary) from ( 
	SELECT EmpSalary from Employee ORDER BY EmpSalary DESC LIMIT 3 
);

Similar codes

1 vote100 views2 answers
Into sql
SQL
0 vote136 views1 answer
Mysql collation portugues brasil
SQL
0 vote119 views1 answer
Mysql bind-address default value
SQL
-1 vote102 views2 answers
Postgres autoincrement primary key
SQL
0 vote111 views1 answer
Normalization in database
SQL
4 votes117 views2 answers
What is table in sql
SQL
1 vote64 views1 answer
Mysql show attributes of a table
SQL
0 vote66 views1 answer
Como leer datos de mysql esp32
SQL
0 vote108 views1 answer
Add alternate add column sql
SQL
8 votes111 views1 answer
Insert a select statement into a table
SQL