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 vote178 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote174 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
8 votes200 views1 answer
Ltrim sql
SQL
4 votes197 views6 answers
Second max salary in sql
SQL
0 vote200 views1 answer
Sql server beginning of month
SQL
0 vote242 views1 answer
Sqlite schema structure of a relational database
SQL
4 votes175 views1 answer
Create table if not exist in sqlite
SQL
0 vote139 views1 answer
Mariadb list tables
SQL
4 votes177 views1 answer
Refresh postgres config
SQL
0 vote183 views1 answer
How to add more columns to a table in mysql
SQL