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 vote157 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote156 views1 answer
How to check even or odd in sql
SQL
0 vote211 views1 answer
Ora 00001 error catch plsql
SQL
0 vote117 views1 answer
Java spring jdbc connect to postgresql
SQL
2 votes191 views2 answers
Convert_tz mysql
SQL
0 vote151 views1 answer
Mysql default timestamp value to be current timestamp
SQL
-1 vote191 views3 answers
SQL MM/dd/yyyy format
SQL
10 votes109 views2 answers
Django mysql
SQL
0 vote164 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
3 votes210 views2 answers
How to list columns for particular tables in postgresql
SQL