offset

Use offset to page through the results of your query.

Skips over the specified number of rows when returning the results of a query. You typically use offset to paginate the query results.

When using offset in your SAQL statements, be aware of these rules:

• The order of filter and order can be swapped because it doesn’t change the results
• offset must be after order
• offset must be before limit
• There can be no more than one offset statement after a foreach statement

This example loads the opportunity dataset, sorts the rows in alphabetical order by account owner, and returns rows 51–101:

See Also

• Statements