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 vote325 views1 answer
Sql avg group by
SQL
1 vote373 views2 answers
Truncate table sqlite
SQL
4 votes333 views4 answers
Sqlite describe table
SQL
0 vote358 views1 answer
View psql output in horizontal scrolling
SQL
0 vote325 views1 answer
Oracle flush Shared Pool
SQL
1 vote325 views1 answer
Create temporal table in sql
SQL
1 vote330 views1 answer
How to drop function in sql
SQL
1 vote282 views1 answer
Ms sql how to see active job current run time
SQL
0 vote342 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
4 votes320 views1 answer
Oracle error compilation line
SQL