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 XXXGROUP BY CustomerHAVING SUM(OrderPrice)<2000;
测试结果
| Customer |
SUM(OrderPrice) |
| Carter |
1700 |
