OQL Limit Clause

1 minute to read Download PDF Edit

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:

SELECT FirstName FROM Sales.Customer
ORDER BY LastName
LIMIT 10

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

SELECT FirstName FROM Sales.Customer
ORDER BY LastName
OFFSET 10

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

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

Copyright © Mendix. All rights reserved. | Mendix.com | Terms of Use | Privacy Policy