Delegation Rules: LIMIT

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

LIMIT allows a certain number of rows to be returned from a query. This is typically used with OFFSET, which determines which block of rows to return.

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