How to get nth number 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

2 votes319 views1 answer
Create delete procedure mysql
SQL
4 votes280 views2 answers
Dbms output
SQL
0 vote316 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote282 views1 answer
Google sheets data validation custom formula filter
SQL
1 vote261 views2 answers
T sql get foreign key
SQL
0 vote253 views1 answer
How to change the field size of an existing column
SQL
0 vote257 views1 answer
Oracle synonym procedure
SQL
0 vote270 views1 answer
Alter fedora mysql 8.0 user
SQL
1 vote312 views1 answer
Import sql file from laravel
SQL
0 vote290 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL