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 vote129 views1 answer
Flask sqlalchemy decimal
SQL
0 vote168 views1 answer
Copy from one table to another postgres using matching column
SQL
2 votes80 views1 answer
Select sid oracle
SQL
0 vote141 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
2 votes128 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
1 vote145 views2 answers
This month mysql where
SQL
3 votes185 views2 answers
Mysql user permission database
SQL
0 vote126 views1 answer
Sql last 7 days
SQL
1 vote139 views1 answer
Flask sqlalchemy default value
SQL
1 vote124 views1 answer
Declare table variable
SQL