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 vote351 views1 answer
Oracle drop type
SQL
2 votes339 views1 answer
SQL column name Postgre
SQL
0 vote325 views1 answer
Mysql database is not starting in xampp
SQL
0 vote316 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote336 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
1 vote335 views1 answer
Adding a check statement in sql
SQL
0 vote399 views1 answer
Osm2pgsql mac
SQL
4 votes337 views4 answers
Sqlite describe table
SQL
0 vote353 views1 answer
How to start my sql server on mac
SQL
1 vote334 views3 answers
Postgresql crete view
SQL