Between

Table of Contents



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.


round-pushpin Selects records where the Id falls between a given range.
SELECT * FROM WordList:Word WHERE Id BETWEEN 600000 AND 600010

round-pushpin Selects records where the Id does not fall between a given range.
SELECT * FROM WordList:Word WHERE Id NOT BETWEEN 0 AND 891930


SQL :: Not
The NOT keyword performs a not operation on logical operators such as LIKE and BETWEEN.
SQL::Keywords
A breakdown of all high-level statements available via the query handler.