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 vote174 views1 answer
Sql upsert
SQL
22 votes191 views3 answers
Remove all records from table mysql
SQL
0 vote213 views1 answer
Virtuoso sql query tutorial
SQL
0 vote179 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote211 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote195 views1 answer
Kotlin sqlite delete row
SQL
2 votes192 views1 answer
Sql server find columns list in tables
SQL
0 vote211 views1 answer
How to add mysql to path on termin after installation
SQL
5 votes189 views2 answers
Ranking functions in sql
SQL
15 votes235 views4 answers
Export mysql db using command line
SQL