Mendix 7 is no longer supported unless you have Extended Support. Mendix 7 documentation will remain available until July 2024.

OQL Limit Clause

Last modified: July 4, 2023

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.