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 vote183 views2 answers
Delete auto increment mysql
SQL
1 vote369 views1 answer
Postgres convert text to number
SQL
0 vote211 views1 answer
Not equal to blank in mysql
SQL
0 vote232 views1 answer
Kill a pid redshift
SQL
0 vote221 views1 answer
Mysql query problems and solutions
SQL
0 vote223 views1 answer
Get a list of tables and the primary key
SQL
0 vote219 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
1 vote224 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
3 votes303 views4 answers
Sql interview questions
SQL
0 vote225 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL