OQL Limit Clause

Last modified: May 29, 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.

1
2
3


SELECT FirstName FROM Sales.Customer
ORDER BY LastName
LIMIT 10

This query retrieves the first ten customers, sorted by their last name.

1
2
3


SELECT FirstName FROM Sales.Customer
ORDER BY LastName
OFFSET 10

This query retrieves all customers, except the first ten, sorted by their last name.

1
2
3


SELECT FirstName FROM Sales.Customer
ORDER BY LastName
LIMIT 10 OFFSET 10

This query retrieves the 11th to 20th customer, sorted by their last name.