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 vote316 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote419 views1 answer
Delet all record statment sql
SQL
16 votes344 views3 answers
Update table from another table
SQL
0 vote294 views1 answer
Duplicate foreign key constraint name
SQL
0 vote352 views1 answer
Sql query to find percentage of null values in a table
SQL
6 votes334 views2 answers
Postgresql pg_dump
SQL
0 vote319 views1 answer
Complete date is 1 year or not sql server
SQL
38 votes331 views4 answers
Count sql
SQL
1 vote329 views1 answer
Flask sqlalchemy default value
SQL
1 vote346 views3 answers
Sql union
SQL