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

11 votes367 views2 answers
Oracle source code
SQL
0 vote389 views2 answers
How to check if a column exists in a SQL Server table?
SQL
2 votes330 views1 answer
Pandas to sql index
SQL
0 vote329 views1 answer
Sql get month from date
SQL
0 vote286 views1 answer
Java spring boot connect to sql server
SQL
2 votes324 views1 answer
Sql create database
SQL
0 vote356 views1 answer
Sql query use select name inside where clause
SQL
11 votes318 views2 answers
Having clause
SQL
0 vote362 views1 answer
Bitmap join index
SQL
4 votes338 views6 answers
Second max salary in sql
SQL