求SQL语句,既有count,又有sum该怎么做?ID Name ShuLiang 1张三32李四53张三1查询结果:Name ShuLiang CiShu
求SQL语句,既有count,又有sum该怎么做?
ID Name ShuLiang
1 张三 3
2 李四 5
3 张三 1
查询结果:
Name ShuLiang CiShu
张三 4 2
李四 5 1
[解决办法]
select name,sum(shuliang)as shuliang,count(*) as cishu
from tb group by name
