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 vote295 views1 answer
List MySQL Table and Index Size
SQL
6 votes307 views6 answers
Count mysql
SQL
7 votes285 views2 answers
Create index mysql
SQL
0 vote327 views1 answer
Running percentage of total postgres
SQL
0 vote356 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote332 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote299 views1 answer
Sub query in linq
SQL
2 votes338 views3 answers
Mysql kill
SQL
3 votes307 views1 answer
Force using index oracle
SQL
6 votes355 views5 answers
Oracle list tablespaces
SQL