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

2 votes183 views1 answer
Update trigger
SQL
7 votes204 views5 answers
Oracle alter table
SQL
4 votes205 views3 answers
Is not null sql
SQL
0 vote201 views1 answer
Sql decode
SQL
0 vote215 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote198 views1 answer
Drop column from table if exist on live server mysql
SQL
1 vote200 views1 answer
Psql human readable
SQL
1 vote182 views1 answer
How to see all table partition in oracle
SQL
0 vote219 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
2 votes198 views3 answers
Mysql pass command from command line
SQL