关键字:AND, OR, NOT, BETWEEN, IN, IS, NULL
1. AND
SELECT
CustomerName,
QuantityPurchased
FROM Orders
WHERE QuantityPurchased > 3
AND QuantityPurchased < 7
只返回那些QuantityPurchased 大于3且小于7的行(每个条件都必须真)
2. OR
SELECT
CustomerName,
QuantityPurchased,
PricePerItem
FROM Orders
WHERE QuantityPurchased > 8
OR PricePerItem > 3
只返回那些购买量大于8或者单价大于3的行(对于每一行,只要其一条件为真即可)
优先级AND > OR (注意使用括号以保证正确的逻辑组合条件的执行)
SELECT
CustomerName,
State,