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 vote277 views1 answer
Connect by query in oracle
SQL
0 vote260 views1 answer
How to insert multiple rows in mysql using laravel
SQL
-3 votes276 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
1 vote252 views1 answer
Count of tables in database mysql
SQL
0 vote239 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote260 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote257 views1 answer
Pass array parameter to stored procedure c#
SQL
2 votes256 views2 answers
Mysql on duplicate key ignore
SQL
0 vote265 views2 answers
Unique key
SQL
0 vote247 views1 answer
Postgresql find missing id
SQL