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

3 votes195 views1 answer
Select nextval from sequence sql
SQL
17 votes193 views6 answers
Sql select distinct
SQL
0 vote184 views1 answer
Sql random decimal
SQL
0 vote190 views2 answers
Postgresql change user role grant
SQL
1 vote186 views3 answers
Rename table snowflake
SQL
0 vote219 views1 answer
Alter owner in PostgreSQL
SQL
0 vote178 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote213 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
-1 vote192 views2 answers
Postgres autoincrement primary key
SQL
0 vote201 views1 answer
If column value is null then in mysql
SQL