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

0 vote261 views1 answer
Insert query return id mysql
SQL
0 vote201 views1 answer
Sql select merge multiple values
SQL
0 vote255 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote223 views1 answer
Sql sum if
SQL
2 votes219 views2 answers
Storing timezones in postgres
SQL
1 vote220 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
2 votes222 views1 answer
Power query concatenate
SQL
0 vote193 views1 answer
Mysql autoincrement valor inicial
SQL
1 vote203 views2 answers
Mysql trim spaces
SQL
0 vote197 views1 answer
Google cloud sql postgres url example
SQL