BETWEEN AND Operator

The BETWEEN . . . AND comparison operator is used when searching a field for values falling within a specified range

SELECT title, pubid
FROM books
 WHERE pubid BETWEEN 1 AND 3

SELECT title

FROM books
 WHERE title BETWEEN 'A' AND 'D'

Back To Top- Home - Category