最近敲代码时遇到一个问题:我想要群组计数(Count() group by)和全部计数(Count() as total),怎么处理呢?
id | name | age |
1 | 小明 | 8 |
2 | 小林 | 7 |
3 | 小王 | 8 |
4 | 小黄 | 9 |
5 | 小花 | 8 |
6 | 小徐 | 6 |
Select age, Count(*) AS AgeNum, Sum(Count(*)) OVER() AS Total
From TableA
Group By age
Order By age Asc
age | AgeNum | Total |
6 | 1 | 6 |
7 | 1 | 6 |
8 | 3 | 6 |
9 | 1 | 6 |