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

1 vote164 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
9 votes157 views6 answers
Sql add column with default value
SQL
0 vote160 views1 answer
Tinydb add table
SQL
6 votes167 views2 answers
Postgresql pg_dump
SQL
1 vote139 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote171 views1 answer
SELECT statement to find the specific cell in database table
SQL
3 votes178 views3 answers
Mysql auto increment after delete
SQL
0 vote142 views1 answer
Formatting code with SQL Developer
SQL
0 vote166 views1 answer
Create query in where clasue
SQL
4 votes157 views6 answers
Second max salary in sql
SQL