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 vote297 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
-1 vote293 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
14 votes274 views3 answers
SQL trim
SQL
14 votes311 views4 answers
Sql compiler
SQL
60 votes455 views6 answers
Add column in sql
SQL
1 vote281 views1 answer
Alter constraint postgres
SQL
2 votes255 views1 answer
Mysql add boolean column
SQL
1 vote285 views1 answer
Sql server epoch to datetime
SQL
0 vote277 views1 answer
Update database collation in postgresql
SQL
0 vote309 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL