在 SQL 中增加 HAVING 子句原因是,WHERE 关键字无法与合计函数一起使用。
SELECT [ ALL | DISTINCT ]
{ * | projectItem [, projectItem ]* }
FROM tableExpression
[ WHERE booleanExpression ]
[ GROUP BY { groupItem [, groupItem ]* } ]
[ HAVING booleanExpression ];
测试数据
Customer | OrderPrice |
---|---|
1000 | Bush |
1600 | Carter |
700 | Bush |
300 | Bush |
2000 | Adams |
100 | Carter |
SELECT Customer,SUM(OrderPrice) FROM XXX
GROUP BY Customer
HAVING SUM(OrderPrice)<2000;
测试结果
Customer | SUM(OrderPrice) |
---|---|
Carter | 1700 |
在文档使用中是否遇到以下问题
更多建议
匿名提交