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 vote136 views1 answer
Oracle show execution plan
SQL
18 votes117 views6 answers
Create table mysql
SQL
0 vote109 views1 answer
Postgres add prefix to primary key
SQL
15 votes133 views6 answers
Laravel db transaction
SQL
7 votes122 views5 answers
Show details of table postgres
SQL
0 vote104 views1 answer
How to find top 3 salary in sql
SQL
0 vote113 views2 answers
Sql select inside select
SQL
1 vote141 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
3 votes113 views2 answers
How to load files in mysql
SQL
1 vote110 views1 answer
Postgresql convert text to float
SQL