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

9 votes365 views3 answers
Date format in sql
SQL
0 vote344 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote344 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote334 views1 answer
Sql server remove 0 from left
SQL
3 votes295 views2 answers
Mysql sum with condition
SQL
0 vote381 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote329 views1 answer
Sqlite select split string
SQL
0 vote364 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote357 views1 answer
Sql shell psql cannot enter password
SQL
1 vote359 views1 answer
Mysql show database size in mb
SQL