操作符between and

操作符 BETWEEN ... AND 会选取介于两个值之间的数据范围。这些值可以是数值、文本或者日期。

SELECT * FROM Persons where id between 3 and 5

SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'