Question

sql表中同一个用户名有不同条记录,每个记录都有数量这个字段，我想求按用户名查处每个记录数量的总和

我写的这个是错的，求指教
select Count(*) from jieyuejilu where jieyueshuliang=(select jieyuerenyonghuming from jieyuejilu where jieyuerenyonghuming= 'WW' );

Answer 1

select name,sum(money) from 表名 group by name;