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 votes291 views1 answer
Apex date today add days
SQL
0 vote296 views2 answers
T SQl Checking Your Username
SQL
1 vote296 views1 answer
Apex select list ORA-20999
SQL
2 votes327 views6 answers
Mysql change timezone
SQL
0 vote318 views1 answer
Oracle running queries
SQL
0 vote341 views1 answer
C# sql transaction multiple connections
SQL
0 vote318 views1 answer
Mysql uuid
SQL
0 vote293 views1 answer
Sql select with apostrohpe
SQL
1 vote294 views1 answer
Mysql show table character set
SQL
0 vote336 views1 answer
Sql sort ages
SQL