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 vote222 views1 answer
Flush user resource mysql
SQL
0 vote242 views1 answer
Select * from mysql.proc
SQL
0 vote223 views1 answer
Oracle to_number
SQL
0 vote246 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
3 votes211 views3 answers
Mysql get table size
SQL
0 vote210 views1 answer
Replace \n sql
SQL
0 vote221 views1 answer
Select from column mysql
SQL
5 votes213 views1 answer
Oracle sysdate
SQL
1 vote228 views1 answer
Error code 1292 mysql workbench
SQL
0 vote225 views1 answer
Sql server Cost Fifo query
SQL