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 vote280 views1 answer
Add many column to sap iq table
SQL
0 vote279 views1 answer
Postgres regex word boundary
SQL
10 votes218 views1 answer
Oracle view dependencies
SQL
0 vote268 views4 answers
Convert databse to achieve log mode oracle
SQL
8 votes259 views4 answers
Mysql update one table from another table multiple columns
SQL
93 votes348 views4 answers
Create database postgres
SQL
1 vote224 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
1 vote274 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote267 views4 answers
Change schema in sql server
SQL
5 votes272 views2 answers
To date oracle
SQL