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

0 vote264 views1 answer
IIF
SQL
1 vote279 views2 answers
Regex starts with
SQL
0 vote286 views1 answer
Default column value in sql same as another column laravel
SQL
1 vote269 views1 answer
Select 2 rows in sql
SQL
9 votes280 views2 answers
Sql limit to 5 results
SQL
0 vote267 views1 answer
Sqlite closes value
SQL
0 vote285 views1 answer
Function plsql
SQL
0 vote290 views1 answer
List all indexes postgres
SQL
5 votes285 views5 answers
Find max number in sql
SQL
0 vote254 views1 answer
How to insert same table data using mysql query
SQL