在sqlsever中表结构如下
id fno fdate cartid manfest weight
1 asd asd as asdf 120
2 asd asd as asdf 120
3 asd asd as asdf 100
4 asd asd as asd 20
5 asd asd as asdf 120
6 asd asd as asd 20
要求查询如下结果
也就是按weight字段进行合并汇总
fno fdate cartid manfest weight
asd asd as asdf 360
asd asd as asdf 40
进行显示.
id fno fdate cartid manfest weight
1 asd asd as asdf 120
2 asd asd as asdf 120
3 asd asd as asdf 100
4 asd asd as asd 20
5 asd asd as asdf 120
6 asd asd as asd 20
要求查询如下结果
也就是按weight字段进行合并汇总
fno fdate cartid manfest weight
asd asd as asdf 360
asd asd as asdf 40
进行显示.
from
tb
group by fno,fdate,cartid,manfest