在使用聚合函数时,您需要添加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
在文档使用中是否遇到以下问题
更多建议
匿名提交