Mendix 7 is no longer supported unless you have Extended Support (for details, please contact Mendix Support). Mendix 7 documentation will remain available for customers with Extended Support 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.