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

5 votes159 views2 answers
Oracle list columns
SQL
-1 vote153 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote156 views1 answer
Mysql insert into select transaction c#
SQL
0 vote147 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
3 votes126 views1 answer
Start mysql server linux terminal
SQL
0 vote156 views1 answer
Sqlalchemy query join many to many
SQL
2 votes97 views1 answer
Oracle current date without time
SQL
2 votes149 views5 answers
Eloquest how to select one specific column in database
SQL
1 vote140 views1 answer
Tsql get beginning of year
SQL
0 vote139 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL