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 vote128 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote178 views1 answer
Generate random & unique mysql string
SQL
0 vote144 views1 answer
Oracle allow space to user
SQL
6 votes92 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote138 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote132 views1 answer
Run mssql server terminal
SQL
0 vote151 views1 answer
Sql output select
SQL
1 vote136 views1 answer
Mysql get domain from url
SQL
0 vote136 views1 answer
Phpmyadmin tabellentyp ändern
SQL
1 vote142 views1 answer
Increase existing date in sql
SQL