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 vote154 views1 answer
Sqlite show columns in table
SQL
3 votes132 views1 answer
What is having
SQL
1 vote104 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote122 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote106 views1 answer
How to install mysql without admin rights
SQL
0 vote102 views1 answer
How to order result of subquery in select
SQL
0 vote107 views1 answer
Install squirrel sql ubuntu
SQL
1 vote138 views1 answer
Primary key reset in SQL database
SQL
19 votes130 views6 answers
Create table sqlite
SQL
1 vote133 views1 answer
How do you use sql in you company
SQL