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

11 votes177 views2 answers
Set default column value sql
SQL
0 vote159 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote139 views1 answer
Sql clear table
SQL
16 votes170 views3 answers
Get count of duplicate records
SQL
1 vote145 views1 answer
Delete mysql from mac
SQL
3 votes136 views1 answer
Oracle nextval
SQL
1 vote149 views1 answer
Sql into vs insert into
SQL
18 votes162 views6 answers
Laravel form validation
SQL
31 votes164 views2 answers
Grant all priviledges to mysql user
SQL
0 vote142 views1 answer
How to count null values in sql
SQL