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 vote181 views4 answers
Alter schema sql
SQL
3 votes142 views1 answer
Insert into table from another table mysql
SQL
0 vote145 views1 answer
Sql max of two values
SQL
0 vote140 views1 answer
Convert int to varchar sql
SQL
0 vote125 views1 answer
Find largest table in mysql database
SQL
0 vote142 views1 answer
Sqlserver now
SQL
3 votes142 views2 answers
Postgres alter table owner
SQL
7 votes141 views5 answers
Sql remove spaces
SQL
11 votes136 views2 answers
Having clause in sql
SQL
0 vote186 views1 answer
Drop view sql
SQL