How to get specific salary in sql

Here is the solution for nth highest
salary from employees table 

SELECT FIRST_NAME , SALARY FROM 
(SELECT FIRST_NAME, SALARY, DENSE_RANK() OVER
(ORDER BY SALARY DESC) AS SALARY_RANK
FROM EMPLOYEES)
WHERE SALARY_RANK = n;

Similar codes

29 votes174 views5 answers
Mysql show table structure
SQL
1 vote187 views3 answers
Nth highest salary
SQL
5 votes178 views3 answers
Postgres show databases
SQL
0 vote178 views1 answer
Mysql conf.d exampel
SQL
3 votes180 views1 answer
Select sequence oracle
SQL
0 vote165 views1 answer
Alter table myisam to innodb
SQL
4 votes175 views2 answers
Convert utc to est sql
SQL
6 votes190 views2 answers
Psql load dump
SQL
0 vote174 views1 answer
Sql #region
SQL
0 vote171 views1 answer
Coalesce for comma separated in sql server
SQL