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
Create function syntax sql server
SQL
0 vote121 views1 answer
Power query case when
SQL
0 vote195 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote100 views1 answer
Oracle sysdba connect as another user
SQL
4 votes211 views4 answers
Update select mysql
SQL
2 votes116 views1 answer
Oracle sql drop table purge
SQL
0 vote127 views1 answer
Oracle drop default value
SQL
4 votes122 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote123 views2 answers
How to tun mysql on ubunto
SQL
0 vote142 views1 answer
Show table structure mysql console
SQL