LIMIT and OFFSET Examples

The following example illustrates the use of LIMIT AND OFFSET where 50 rows are returned beginning at row 20.

Example 1:

SELECT city FROM table WHERE obj EnvelopesIntersect <geometry> LIMIT 50 OFFSET 20

Example 2:

If the data source provider does not support LIMIT and /or OFFSET, the data provider will act on this query:

SELECT city FROM table WHERE obj EnvelopesIntersect <geometry>

Spectrum will perform the LIMIT and OFFSET

SELECT city FROM <results of the non-delegated query> LIMIT 50 OFFSET 20