How to get nth number 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 vote268 views1 answer
How to search query in python3 sqlite3
SQL
0 vote338 views1 answer
How to show current database in mysql
SQL
0 vote265 views1 answer
Sql composite key
SQL
0 vote252 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote294 views1 answer
Get last inserted primary key
SQL
0 vote266 views1 answer
T-SQL Create Trigger
SQL
7 votes270 views5 answers
Sql remove spaces
SQL
0 vote384 views1 answer
Sql developer export connections
SQL
0 vote295 views1 answer
Show all sequences postgres
SQL
3 votes267 views1 answer
Select database in sql
SQL