How to get specific salary 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

4 votes299 views1 answer
Postgresql show current database
SQL
2 votes363 views3 answers
How to replace null values in sql
SQL
1 vote286 views2 answers
Mysql SELECT
SQL
0 vote336 views1 answer
Insert ip address in mysql
SQL
1 vote308 views1 answer
Mysql monthname
SQL
8 votes304 views1 answer
Mysql restore database
SQL
0 vote337 views1 answer
Make parameters nullable in sql server
SQL
-1 vote327 views1 answer
Sql show custom constraints
SQL
0 vote310 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote362 views1 answer
Update mysql from paypal shopping cart and ipn
SQL