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 votes181 views1 answer
Oracle current date without time
SQL
5 votes190 views2 answers
Create function postgresql
SQL
0 vote183 views1 answer
Mysql update from n to 100
SQL
5 votes163 views2 answers
Create table
SQL
16 votes198 views2 answers
Mysql date between two dates
SQL
0 vote199 views1 answer
Add two days to current date in sql when creating tables
SQL
3 votes198 views2 answers
Sql end of month
SQL
0 vote187 views1 answer
How to create a table in sql stack overflow
SQL
2 votes181 views1 answer
Sql ends with string
SQL
17 votes172 views2 answers
How to assign date field for table in mysql
SQL