BETWEEN selects values within a given range. Works with numbers, dates, and text.

Basic BETWEEN Syntax

SELECT * FROM table WHERE column BETWEEN value1 AND value2;

Number Range

SELECT * FROM products WHERE price BETWEEN 10 AND 100;

Date Range

SELECT * FROM orders

WHERE order_date BETWEEN '2025-01-01' AND '2025-12-31';

NOT BETWEEN

SELECT * FROM products WHERE price NOT BETWEEN 50 AND 100;

BETWEEN with Time

SELECT * FROM logs

WHERE created_at BETWEEN '2025-01-01 00:00:00' AND '2025-01-01 23:59:59';

BETWEEN is Inclusive

-- Includes both endpoints

WHERE price BETWEEN 10 AND 20

-- Same as

WHERE price >= 10 AND price <= 20

Generate Range Queries

Describe your range and AI2sql creates the BETWEEN query.