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 vote148 views1 answer
Left join in codeigniter query builder
SQL
0 vote156 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
6 votes142 views2 answers
If not exists insert sql
SQL
39 votes227 views4 answers
Select duplicates in sql
SQL
1 vote166 views1 answer
Sqlite create index
SQL
0 vote142 views1 answer
Parsing float to int in mysql
SQL
1 vote140 views1 answer
Mysql show current queries
SQL
0 vote155 views1 answer
Postgresql in vs any performance
SQL
1 vote171 views1 answer
How to show index type in postgresql
SQL
0 vote144 views1 answer
Pl/sql loop example
SQL