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 vote172 views1 answer
C# check if mysql query modified rows
SQL
0 vote178 views2 answers
Tsql row number
SQL
0 vote176 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
1 vote177 views1 answer
Join first name and last name sql
SQL
1 vote198 views3 answers
Sql procedure
SQL
0 vote206 views10 answers
Sql statement checker corrector
SQL
0 vote167 views1 answer
Recover deleted data from mysql database
SQL
0 vote182 views1 answer
Flask sqlalchemy session delete
SQL
1 vote180 views2 answers
Oracle list service names
SQL
1 vote180 views2 answers
How to add amount between date in sql
SQL