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

2 votes169 views1 answer
Oracle log files
SQL
0 vote123 views1 answer
Opensuse stop MySQL
SQL
0 vote103 views1 answer
Postgres create database if not exists
SQL
3 votes147 views1 answer
Increment integer in table sql
SQL
0 vote132 views1 answer
Get only one row in mysql
SQL
0 vote127 views1 answer
Cast for print sql
SQL
0 vote126 views1 answer
Order by ip address sql
SQL
0 vote132 views1 answer
Number(10 2) in sql means
SQL
27 votes150 views3 answers
Mysql show tables in database
SQL
2 votes133 views4 answers
How to find 2nd highest salary in mysql
SQL