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 vote335 views1 answer
Python mysqlclient library not found for -lssl
SQL
1 vote356 views1 answer
Drop table if exists oracle
SQL
0 vote357 views2 answers
Add colum in sql
SQL
3 votes444 views1 answer
Sql select second max
SQL
5 votes344 views4 answers
Change auto increment mysql
SQL
0 vote365 views1 answer
Date datatype in livesql
SQL
3 votes340 views4 answers
Stop MySQL
SQL
0 vote343 views1 answer
Sql server set complex constraints
SQL
0 vote327 views1 answer
How to get table current identity value in sql server
SQL
0 vote350 views2 answers
Mysql decimal remove trailing zeros
SQL