使用 BETWEEN
运算符选择所有记录
ProductName
列按字母顺序排列在“Geitost”和“Pavlova”之间。
SELECT * FROM Products
WHERE ProductName
@(31);
SELECT * FROM Products
WHERE ProductName
BETWEEN 'Geitost' AND 'Pavlova';
SELECT * FROM Products
WHERE ProductName
BETWEEN "Geitost" AND "Pavlova";
SELECT * FROM Products
WHERE ProductName
BETWEEN 'Geitost' AND "Pavlova";
SELECT * FROM Products
WHERE ProductName
BETWEEN "Geitost" AND 'Pavlova';