SELECT prod_name,prod_price FROM Products WHERE prod_price BETWEEN 3 AND 6 ORDER BY prod_price; 或 SELECT prod_name,prod_price FROM Products WHERE prod_price >= 3 AND prod_price <= 6 ORDER BY prod_price; 考察点3 <= 界] 包含上下界 ‘prod_price >= 3 AND prod_price <= 6’包含上下界的时候需要用AND连接 直接‘3 <=...