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 vote265 views1 answer
Min salary in sql
SQL
0 vote366 views1 answer
Sqlite display data in separated columns
SQL
1 vote307 views1 answer
Tsql replace value in json
SQL
0 vote319 views1 answer
FIND most frequent word in sql server
SQL
1 vote281 views1 answer
Sql server datetime vs datetime2
SQL
1 vote286 views1 answer
Apex ORA-20999
SQL
1 vote279 views2 answers
Drop function in sql
SQL
6 votes266 views1 answer
Postgresql get year
SQL
0 vote288 views1 answer
How to check which table has data in mysql
SQL
0 vote386 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL