Limit, Offset, Fetch

Limit

The LIMIT clause limits the amount of retrieved rows based on the specified limit.

Syntax

SELECT <columns> FROM <table-name> LIMIT <limit>; 

Example

SELECT * FROM Companies LIMIT 3; 

Offset

The OFFSET clause offsets the first set of rows given by an ORDER BY clause.

Syntax

SELECT <columns> FROM <table-name>
ORDER BY <attribute-name>
OFFSET <offset>; 

Example

SELECT * FROM Companies
ORDER BY name
OFFSET 2
LIMIT 1; 

Fetch

The FETCH clause is used with ORDER BY and OFFSET to retrieve rows.

Syntax

SELECT <columns> FROM <table-name>
ORDER BY <attribute-name>
OFFSET <offset>
FETCH <fetch-details>; 

Example

SELECT * FROM Companies
ORDER BY name
OFFSET 2
FETCH FIRST 2 ROW ONLY;