Skip to main content


Anatomy of a DPQL query

The LIMIT clause enables you to limit the number of rows returned. If you don’t specify a limit amount, a default limit of 2500 will be used to ensure correct operation.

You can use the OFFSET clause to skip over a certain number of rows before returning the LIMIT amount of rows. The OFFSET defaults to 0.

Authors list

First published: 16/03/2017

Last updated: Mar 16, 2017 by Colin Dunn