Between

Table of Contents

Overview
The between keyword allows a query to retrieve data that either does or does not fall withing a given range.

The between will include values that are between the given range but also includes the beginning and ending range values.

Selects records where the Id falls between a given range.

SELECT * FROM WordList:Word WHERE Id BETWEEN 600000 AND 600010

Selects records where the Id does not fall between a given range.

SELECT * FROM WordList:Word WHERE Id NOT BETWEEN 0 AND 891930

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.