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

1 vote227 views1 answer
Does insert into overwrite sql
SQL
0 vote197 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote180 views1 answer
Learn sqlite dart
SQL
2 votes208 views1 answer
Drop all foreign key constraints mysql
SQL
4 votes188 views2 answers
Sql server date now
SQL
18 votes198 views6 answers
Mysql create table
SQL
8 votes205 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote240 views1 answer
Selecting from a view SQL
SQL
2 votes288 views2 answers
Mysql compare datetime to another datetime
SQL
1 vote191 views1 answer
Sql delete all values in a column
SQL