| SELECT column,SUM(column) FROM table GROUP BY column
例：
“Sales”表中的原始数据:
Company
Amount
W3Schools
5500
IBM
4500
W3Schools
7100
按照Company字段进行分组，求出每个Company的Amout的合计：
SELECT Company,SUM(Amount) FROM Sales GROUP BY Company
返回结果：
Company
SUM(Amount)
W3Schools
12600
IBM
4500
Having
用途：
指定群组或汇总的搜寻条件。
语法：
SELECT column,SUM(column) FROM table GROUP BY column HAVING SUM(column) condition value
解释：
HAVING << 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] ... 下一页 >> | 
