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 vote395 views1 answer
Tinydb add table
SQL
0 vote357 views1 answer
Equi joins in oracle
SQL
1 vote409 views1 answer
Delete dublicate rows sql
SQL
0 vote365 views1 answer
Sub query in linq
SQL
10 votes428 views6 answers
Mysql set root password
SQL
0 vote342 views1 answer
Sql if else in select
SQL
-1 vote359 views1 answer
Mysql order by on condition
SQL
0 vote571 views1 answer
Multiple row join
SQL
1 vote354 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote405 views1 answer
Snowflake drop column
SQL