where:不能与聚合数据一起使用,筛选条
having:可以与聚合数据一起使用,筛选组
例子:
SELECT Customer,SUM(OrderPrice) FROM Orders WHERE Customer='Bush' OR Customer='Adams' GROUP BY Customer HAVING SUM(OrderPrice)>1500
where:不能与聚合数据一起使用,筛选条
having:可以与聚合数据一起使用,筛选组
例子:
SELECT Customer,SUM(OrderPrice) FROM Orders WHERE Customer='Bush' OR Customer='Adams' GROUP BY Customer HAVING SUM(OrderPrice)>1500