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

8 votes339 views1 answer
How to remove tables from postgresql
SQL
1 vote304 views1 answer
Select not matching data from two tables
SQL
36 votes393 views6 answers
Change column data type sql
SQL
1 vote330 views1 answer
Oracle user last connection date
SQL
3 votes329 views1 answer
Two selects in one query
SQL
1 vote323 views1 answer
Get table which have specific columns in mysql
SQL
0 vote361 views1 answer
Prisma transaction
SQL
3 votes338 views1 answer
Select sequence oracle
SQL
14 votes334 views3 answers
Oracle sql limit results
SQL
1 vote369 views2 answers
Full join
SQL