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 vote213 views1 answer
Get last inserted primary key
SQL
0 vote163 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote169 views1 answer
Sql delimiter to columns
SQL
1 vote157 views1 answer
Name of today sql
SQL
0 vote157 views1 answer
Oracle c# multiple update sql
SQL
0 vote158 views1 answer
Create a sql server database programmatically
SQL
2 votes162 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote142 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote152 views1 answer
Postgresql comandos basicos
SQL
0 vote151 views1 answer
Get number of tables in database sql
SQL