- AND
SELECT *
FROM Customers
WHERE birth_date >= '1990-01-01' AND points > 1000
- OR
SELECT *
FROM Customers
WHERE birth_date >= '1990-01-01' OR points > 1000
SELECT *
FROM Customers
WHERE birth_date > '1990-01-01' OR
(points > 1000 AND state = 'VA')- NOT
SELECT *
FROM Customers
WHERE NOT (birth_date > '1990-01-01' OR points > 1000)<=>
SELECT *
FROM Customers
WHERE birth_date <= '1990-01-01' AND points <=1000homework
SELECT *
FROM order_items
WHERE order_id = 6 AND unit_price * quantity > 30
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
