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 vote127 views1 answer
Sqlite explain plan
SQL
0 vote115 views1 answer
Faire une recherche par liste de mot clé sql
SQL
18 votes155 views2 answers
Sql comments
SQL
0 vote131 views2 answers
Postgresql gset
SQL
0 vote124 views1 answer
Csv to sqlite python
SQL
1 vote160 views2 answers
Laravel jwt generate token
SQL
3 votes122 views2 answers
Current year sql
SQL
0 vote153 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote142 views2 answers
Uninstall postgresql mac
SQL
3 votes136 views1 answer
Null sql
SQL