实例 SQL 逻辑运算符 BETWEEN

x
 
SELECT * FROM Products
WHERE Price BETWEEN 50 AND 60;
        
                    

输出结果

ProductIDProductNameSupplierIDCategoryIDQuantityPerUnitPriceUnitsInStockUnitsOnOrderReorderLevelDiscontinued
51Manjimup Dried Apples24750 - 300 g pkgs.53.000020010False
59Raclette Courdavault2845 kg pkg.55.00007900False