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 vote108 views1 answer
Oracle list proxy users
SQL
2 votes110 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote117 views1 answer
Normalization in database
SQL
0 vote129 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote136 views1 answer
Primary key start from number
SQL
5 votes108 views1 answer
Minecraft java port number
SQL
0 vote132 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
8 votes108 views2 answers
Between operator
SQL
0 vote147 views1 answer
Sql multiple into
SQL
1 vote128 views2 answers
List tables sqlalchemy
SQL