题解 | #返回产品并且按照价格排序#
返回产品并且按照价格排序
https://www.nowcoder.com/practice/560c94bf434e4e77911982e2d7ca0abb
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 <= prod_price <= 6’会直接报错