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 vote114 views1 answer
Print hello world in plsql
SQL
0 vote104 views1 answer
Oracle sql date summer time
SQL
1 vote92 views1 answer
Sql Split string function
SQL
8 votes112 views2 answers
Select current_timestamp - interval '3 days';
SQL
13 votes95 views2 answers
Sql count distinct group by
SQL
0 vote106 views1 answer
Postgres meta command to show all rows in table
SQL
6 votes97 views3 answers
Update with inner join postgres
SQL
1 vote98 views1 answer
Oracle truncate partition
SQL
0 vote110 views1 answer
Interview experience as a call?
SQL
0 vote101 views1 answer
Azure sql server check foreign key
SQL