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

4 votes250 views1 answer
Mysql delete last row
SQL
28 votes252 views4 answers
Delete database mysql
SQL
5 votes248 views6 answers
Sql foreign key
SQL
3 votes224 views2 answers
Mysql HAVING
SQL
0 vote228 views1 answer
Select top 3 sql
SQL
1 vote245 views1 answer
Pl sql insert into table
SQL
0 vote239 views1 answer
Login failed for user sql server
SQL
1 vote229 views1 answer
Tsql random number
SQL
11 votes239 views1 answer
Oracle view ddl
SQL
7 votes241 views1 answer
Sql disable safe mode
SQL