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

4 votes269 views4 answers
Remove duplicate old value in mysql
SQL
2 votes184 views1 answer
Cast string to datetime mysql
SQL
0 vote180 views1 answer
Oracle right characters
SQL
0 vote178 views1 answer
Mysql convert charset
SQL
3 votes186 views3 answers
Postgresql random number
SQL
0 vote249 views1 answer
Best sql collation
SQL
1 vote205 views1 answer
Get current date in pyspark sql
SQL
1 vote198 views2 answers
Mysql error 1215
SQL
2 votes162 views1 answer
Oracle current date without time
SQL
7 votes181 views1 answer
Safe update mysql
SQL