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 vote175 views1 answer
Drop all tables in azure sql database
SQL
0 vote194 views1 answer
Select from 3 tables one is empty
SQL
5 votes188 views1 answer
Sqlite alter table add column
SQL
10 votes213 views3 answers
Join multiple tables sql
SQL
0 vote198 views1 answer
Mysql date format unix timestamp
SQL
1 vote208 views1 answer
Sql set auto increment back to 0
SQL
5 votes185 views4 answers
Describe table postgres
SQL
12 votes213 views6 answers
Change mysql root password
SQL
2 votes202 views1 answer
Oracle percentage
SQL
1 vote231 views3 answers
Divide by zero error in sql
SQL