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

5 votes220 views2 answers
Mysql dump mysql db cli
SQL
12 votes205 views4 answers
Mysql version
SQL
0 vote216 views1 answer
Copying query result to excel
SQL
0 vote218 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote200 views1 answer
Where case insensitive like mysql
SQL
1 vote219 views3 answers
Nth highest salary
SQL
1 vote209 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote223 views1 answer
Psql show db
SQL
1 vote194 views1 answer
Autocommit mysql
SQL
1 vote212 views2 answers
Postgresql remote connect
SQL