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 vote178 views1 answer
Transaction database with php
SQL
-2 votes192 views2 answers
Sqlserver docker
SQL
0 vote176 views1 answer
Sql constarint
SQL
2 votes169 views2 answers
How to create an empty table from an existing table
SQL
0 vote230 views1 answer
Mysql c commands
SQL
1 vote218 views1 answer
Apex run 404
SQL
1 vote244 views1 answer
Sql select contem uma palavra
SQL
0 vote232 views1 answer
Mysql workbench not showing schemas
SQL
3 votes247 views1 answer
Query less than datetime sql
SQL
3 votes204 views2 answers
How to delete git repo locally
SQL