Name
BETWEEN — Inclusion within a range
Syntax
Description
The BETWEEN expression checks to see if the value
of a test expression is between a minimum expression and a
maximum expression, inclusive. The expression is logically
equivalent to (test >= min AND
test <= max), although the test
expression is only evaluated once. The BETWEEN operator will return a logic value of
0, 1, or NULL, under the rules of three valued
logic.
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
