Between Operator

Between is an operator returns true if the numeric or date values fall within the range.

Example

SELECT city FROM table WHERE pop Between 100000 AND 200000

If the data source provider supports Between, the entire query is delegated to the data source provider.

If the data source provider does not support Between, part of the query is delegated, as follows:

SELECT city, pop FROM table

Spectrum Spatial executes the entire query, using the results from the data source provider:

SELECT city FROM <results from the delegation> WHERE pop Between 100000 AND 200000