Between
Overview
The between keyword allows a query to retrieve data that either does or does not fall withing a given range.
Edge of range inclusion notice
The between will include values that are between the given range but also includes the beginning and ending range values.Example
SELECT * FROM WordList:Word WHERE Id BETWEEN 600000 AND 600010
SELECT * FROM WordList:Word WHERE Id NOT BETWEEN 0 AND 891930
Related
- Not - The NOT keyword performs a not operation on logical operators such as LIKE and BETWEEN.
- Keywords - A breakdown of all high-level statements available via the query handler.