Используйте оператор 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';