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