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

3 votes224 views5 answers
Sql select
SQL
0 vote203 views1 answer
Manage Database in MySQL
SQL
0 vote215 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
1 vote199 views1 answer
Get last week data in mysql
SQL
1 vote206 views1 answer
Pl sql create table from another table
SQL
0 vote201 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote213 views1 answer
Postgresql port 5432 not open
SQL
2 votes198 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote209 views3 answers
Joins and views sql
SQL
3 votes213 views3 answers
Mysql auto increment after delete
SQL