Studio Pro 8 has reached its end of support. To upgrade to a supported version, see Moving from Mendix Studio Pro 8 to 9.

OQL Limit Clause

Last modified: August 27, 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.

SELECT FirstName FROM Sales.Customer
ORDER BY LastName
LIMIT 10

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

SELECT FirstName FROM Sales.Customer
ORDER BY LastName
OFFSET 10

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

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.