Delegation Rules: OFFSET

The following rules apply when determining what can be delegated to a data provider:
  1. OFFSET can be delegated to a data source provider if the data provider supports it.
  2. OFFSET can be delegated if the entire query can be delegated.

OFFSET allows a block of rows to be returned from a query beginning at a certain row. This is typically used with LIMIT, which determines how many rows to return.

For more information on OFFSET, see the Limit and Offset in the MapInfo SQL Reference.