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 vote178 views1 answer
Create table as select sql server error
SQL
14 votes137 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
2 votes143 views1 answer
How to check if a row is null in sql
SQL
1 vote146 views1 answer
Backup mysql data only
SQL
51 votes251 views6 answers
Opera gx
SQL
4 votes150 views2 answers
How to insert ip address in mysql using php
SQL
0 vote154 views1 answer
Postgresql remove new line from string
SQL
0 vote230 views1 answer
Bigrock database connection string
SQL
20 votes136 views1 answer
Get all table name in sql through php
SQL
0 vote140 views2 answers
Pl sql auto increment
SQL