[NOT] BETWEEN

Purpose

This tests whether an expression is situated between two values.

Syntax

Not Between Predicate

Usage Notes

  • A BETWEEN B AND C is equivalent B <= A AND A <= C.
Example
SELECT 2 BETWEEN 1 AND 3 AS res;