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 vote169 views1 answer
Oracle free up space in tablespace
SQL
0 vote207 views1 answer
Snowflake drop column
SQL
1 vote178 views1 answer
Increase existing date in sql oracle
SQL
29 votes170 views6 answers
Delete all rows from table mysql
SQL
18 votes165 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote188 views1 answer
Add mysql database to power bi web
SQL
0 vote185 views1 answer
Sql server rtrim everything after character
SQL
0 vote178 views1 answer
Insert array into mysql column
SQL
0 vote175 views1 answer
Android sqlite add column if not exists
SQL
15 votes266 views5 answers
Select all tables sql
SQL