DavidSzczesniak
1/23/2018 - 12:23 PM

BETWEEN

This is a keyword used to filter results in a range.

\!h NOTE: Number range is inclusive, letter range is NOT.

\!h Example with letters:
SELECT * FROM movies 
WHERE name BETWEEN 'A' and 'J'; 
-- only names beginning with letters 'A' up to but not including 'J'. (alphabetical order)

\!h Example with numbers:
SELECT * FROM movies
WHERE year BETWEEN '1990' and '1999';
-- only movies with the years between 1990 up to and including 1999.