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

0 vote271 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote338 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote322 views2 answers
Impala rename column name
SQL
3 votes289 views1 answer
Dbms_scheduler drop_job
SQL
4 votes279 views1 answer
Check database name postgresql
SQL
0 vote272 views1 answer
Mql5 list all available symbols
SQL
37 votes464 views3 answers
Sql check duplicate value in column
SQL
0 vote245 views1 answer
Get last run query sql server
SQL
0 vote289 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote335 views1 answer
Wordpress make wp user in db
SQL