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 vote211 views1 answer
Describe in sqlite3
SQL
0 vote284 views1 answer
Generate sql from specific migration ef core
SQL
4 votes201 views2 answers
Mysql show indexes on table
SQL
0 vote203 views2 answers
How to update the multiple rows in sql
SQL
0 vote198 views1 answer
Object Information
SQL
3 votes168 views1 answer
Ubuntu install postgresql 12
SQL
2 votes199 views1 answer
Oracle apex list connected users
SQL
3 votes229 views1 answer
Oracle user quota on tablespace
SQL
11 votes212 views1 answer
Sql query to find duplicates in column
SQL
4 votes231 views2 answers
Dbms output
SQL