OQL Limit Clause
Last modified: February 13, 2024
With the limit clause a portion of the result of a query can be returned.
The syntax is as following:
[ LIMIT number ] [ OFFSET number ]
LIMIT Specifies how many rows must be returned.
OFFSET Specifies how many rows must be skipped before returning the result rows.
|
|
This query retrieves the first ten customers, sorted by their last name.
|
|
This query retrieves all customers, except the first ten, sorted by their last name.
|
|
This query retrieves the 11th to 20th customer, sorted by their last name.