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

6 votes262 views1 answer
What is where clause in sql
SQL
0 vote258 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote269 views1 answer
Moodle query first user access
SQL
1 vote291 views1 answer
Avg mysql
SQL
-1 vote241 views2 answers
Sql query examples
SQL
1 vote277 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
2 votes290 views1 answer
Where clause for child record apex
SQL
1 vote282 views1 answer
Error code 1292 mysql workbench
SQL
31 votes263 views1 answer
Postgresql add column with constraint
SQL
0 vote269 views1 answer
List mysql tables and views
SQL