HAVING语句

更新时间：2017-11-23 18:24:14

HAVING 子句

在 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