HAVING 子句
您需要添加HAVING子句,才能使WHERE语句和合计函数一起运用。
语法
SELECT [ ALL | DISTINCT ]{ * | projectItem [, projectItem ]* }
FROM tableExpression
[ WHERE booleanExpression ]
[ GROUP BY { groupItem [, groupItem ]* } ]
[ HAVING booleanExpression ];
示例
测试数据
Customer | OrderPrice |
---|---|
Bush | 1000 |
Carter | 1600 |
Bush | 700 |
Bush | 300 |
Adams | 2000 |
Carter | 100 |
测试语句
SELECT Customer,SUM(OrderPrice) FROM XXX
GROUP BY Customer
HAVING SUM(OrderPrice)<2000;
测试结果
Customer | SUM(OrderPrice) |
---|---|
Carter | 1700 |
本文转自实时计算——
HAVING语句