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 vote304 views1 answer
Mysql read row
SQL
0 vote263 views1 answer
Java spring boot connect to sql server
SQL
0 vote295 views1 answer
Get who is hired in january in sql
SQL
2 votes317 views1 answer
Mysql application.properties spring boot
SQL
2 votes338 views3 answers
Postgres json to string
SQL
0 vote322 views1 answer
Oracle running queries
SQL
0 vote296 views3 answers
Get free card roblox
SQL
0 vote385 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote303 views2 answers
Setval max id postgresql sequence
SQL
3 votes293 views3 answers
Sql current year
SQL