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 vote318 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote280 views1 answer
Oracle search in date columns
SQL
13 votes306 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
6 votes284 views1 answer
Postgresql get year
SQL
23 votes280 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
2 votes298 views1 answer
How to create sql database
SQL
10 votes321 views2 answers
Mysql drop database if exists
SQL
2 votes281 views1 answer
Get first 3 letters name in sql
SQL
1 vote332 views1 answer
Mysql find most common value
SQL
2 votes308 views1 answer
Flask sqlalchemy boolean field
SQL