现在有一个表,有两个字段,其中name有多个重复列
例如 表A: name je
acc 12
acc 56
acc 78
bde 45
bde 65
......
现在要对表A进行统计,要求相同name的je汇总,并计算出重复次数,生成到表B中,其中A有上万条记录
表B: name je num
acc 146 3
bde 110 2
......
例如 表A: name je
acc 12
acc 56
acc 78
bde 45
bde 65
......
现在要对表A进行统计,要求相同name的je汇总,并计算出重复次数,生成到表B中,其中A有上万条记录
表B: name je num
acc 146 3
bde 110 2
......
select name,je=sum(je),num=count(name) into 表B from 表A group by name
from tabA
group by name
group by [Name]
group by [Name]
SUM(je) AS je,
COUNT(*) AS num
FROM tabA
GROUP BY [name]