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

1 vote225 views1 answer
Mysql update inner
SQL
3 votes204 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
2 votes224 views1 answer
Sql string_agg
SQL
1 vote229 views1 answer
Minus vs intersect in sql
SQL
0 vote249 views1 answer
Kimball data warehouse sql calendar
SQL
1 vote204 views2 answers
Begin transaction in sql
SQL
1 vote226 views1 answer
Sql group by sum with condition
SQL
0 vote209 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote329 views1 answer
Placements hackerrank solution
SQL
0 vote204 views1 answer
Oracle sql date summer time
SQL