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 vote197 views1 answer
How get data from database if id not found then search another column
SQL
3 votes192 views1 answer
Fk in insert mysql
SQL
0 vote198 views1 answer
Provide hardcoded value in the mysql query
SQL
1 vote190 views1 answer
Crontab every month
SQL
9 votes183 views2 answers
Mysql change value
SQL
1 vote182 views1 answer
Jooq convert using gbk
SQL
3 votes203 views1 answer
Oracle revoke
SQL
0 vote198 views1 answer
Initcap in mysql
SQL
1 vote179 views1 answer
Stop mysql server mac
SQL
0 vote199 views1 answer
Storing RGBA in mysql db
SQL