使用 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';