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

0 vote179 views1 answer
Grouping by email domain mysql
SQL
1 vote153 views1 answer
Top 10 rows in mysql
SQL
2 votes140 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote134 views1 answer
Mysql cdn link
SQL
0 vote181 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote131 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote129 views1 answer
Check if a word appears at the end sql query
SQL
0 vote176 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
1 vote140 views3 answers
Mysql Server Start
SQL
6 votes151 views3 answers
Sql select last id
SQL