SQL · Reading data

between

An inclusive range test.

sqlRunnable example sql course

Syntax

where value between a and b

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (12), (18), (25))
SELECT minutes FROM lessons WHERE minutes BETWEEN 12 AND 18;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.