使用 GROUP BY 分組結果

GROUP BY 子句按行分組行：

SELECT type, count(*) as c
FROM sys.objects
GROUP BY type

你可以對每個組（聚合函式）應用某些函式來計算組中記錄的總和或計數。