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 vote199 views1 answer
Oracle list user locked
SQL
31 votes178 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote178 views1 answer
Mod in sql
SQL
0 vote165 views1 answer
Sql select maximum column with other columns returned
SQL
3 votes178 views1 answer
Increment integer in table sql
SQL
0 vote174 views1 answer
Create mysql pool connection python flask
SQL
1 vote156 views3 answers
How to filter repeated same result using sql query
SQL
1 vote164 views1 answer
Temp table vs variable table in sql server
SQL
1 vote190 views1 answer
Sql server set variable if exists
SQL
0 vote174 views1 answer
Postgres sequence name
SQL