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

1 vote125 views1 answer
Sql order by timestamp
SQL
3 votes102 views1 answer
Mssql remove column
SQL
1 vote106 views1 answer
Moodle query first user access
SQL
1 vote91 views1 answer
Delete triger pl pg sql
SQL
0 vote99 views1 answer
Oracle free up space in tablespace
SQL
4 votes108 views2 answers
Postgresql default value
SQL
1 vote105 views1 answer
Login to database mysql terminal
SQL
1 vote110 views2 answers
Reset mysqli fetch_arra
SQL
4 votes114 views2 answers
Oracle sql group by date year
SQL
24 votes104 views5 answers
Sql reset auto increment
SQL