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 vote369 views1 answer
How to show current database in mysql
SQL
0 vote303 views2 answers
Faster mysql imports
SQL
0 vote270 views1 answer
Back up stored procedures mysql
SQL
1 vote267 views1 answer
Mysql find tables with column name
SQL
2 votes352 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote284 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
1 vote270 views1 answer
GROUP BY clause; this is incompati
SQL
3 votes291 views4 answers
Psql list tables in schema
SQL
0 vote279 views1 answer
Sql string contains case sensitive
SQL
9 votes301 views4 answers
How to alter table column name in mysql
SQL