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

4 votes209 views1 answer
Describe table mysql
SQL
0 vote228 views1 answer
How to subquey to do not load in live database in
SQL
0 vote197 views1 answer
Sql server alter table add column tinyint
SQL
1 vote193 views1 answer
Sqlserver create table from select
SQL
5 votes189 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
6 votes190 views1 answer
Oracle trigger after logon on schema
SQL
0 vote193 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote263 views1 answer
Oracle create package specification
SQL
0 vote192 views1 answer
Drop unique
SQL
7 votes172 views6 answers
Reset identity column in sql server
SQL