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 20Example 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