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

2 votes165 views1 answer
Sql as
SQL
0 vote328 views1 answer
Sql change a colum to unique
SQL
0 vote168 views1 answer
Delete * from where id = 1;
SQL
0 vote194 views1 answer
Redshift running queries
SQL
4 votes164 views1 answer
Postgres delete last row
SQL
0 vote159 views1 answer
How to check if there is no database schema
SQL
0 vote167 views1 answer
How to add session data into mysql database from button
SQL
0 vote172 views1 answer
Mariadb alter table add column if not exists example
SQL
1 vote134 views1 answer
Unique vs distinct sql
SQL
0 vote180 views1 answer
Drop specific row postgresql
SQL