1.
SELECT productCode, productName, buyPrice FROM products WHERE buyPrice BETWEEN 90 AND 100; 在90和100之间
BETWEEN : 在…之间
MySQL BETWEEN运算符
最新推荐文章于 2024-05-26 21:24:28 发布
1.
SELECT productCode, productName, buyPrice FROM products WHERE buyPrice BETWEEN 90 AND 100; 在90和100之间
BETWEEN : 在…之间