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 vote335 views1 answer
Select other columns with distinct
SQL
0 vote385 views1 answer
Sql multiple into
SQL
16 votes366 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
51 votes738 views6 answers
Installing mysql on ubuntu
SQL
-1 vote286 views1 answer
Mysql how to set update or create
SQL
1 vote324 views1 answer
Stored procedure return value
SQL
-2 votes348 views1 answer
Use of where in left join in mysql
SQL
0 vote352 views1 answer
Mysql bind-address default value
SQL
2 votes369 views1 answer
Can you use a where clause for a child query
SQL
0 vote356 views1 answer
Mysql date minus 1 day
SQL