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

0 vote235 views1 answer
Power bi union columns
SQL
0 vote235 views1 answer
Sql server datetime
SQL
2 votes245 views1 answer
Ssh mysql port forwarding
SQL
0 vote217 views1 answer
Full syntax inner join
SQL
0 vote225 views1 answer
Sql count total by foreign key
SQL
0 vote259 views1 answer
Delete a temporary table mysql
SQL
0 vote253 views1 answer
PGSQL dynamic table name
SQL
-1 vote256 views1 answer
Sql show custom constraints
SQL
0 vote242 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
10 votes233 views2 answers
Sql rtrim
SQL