id code name load re
1 001 abc 11 asdsdfasdfasdf
2 002 abc 12 asdsdfasdfasdf
3 001 abc 13 asdsdfasdfasdf
4 002 abc 15 asdsdfasdfasdf
5 001 abc 12 asdsdfasdfasdf
表名为 load_info 以上是表结构,及示例数据,才能查写sql才返回按code分组每组load的和并且,re列也要在返回列表中呢
1 001 abc 11 asdsdfasdfasdf
2 002 abc 12 asdsdfasdfasdf
3 001 abc 13 asdsdfasdfasdf
4 002 abc 15 asdsdfasdfasdf
5 001 abc 12 asdsdfasdfasdf
表名为 load_info 以上是表结构,及示例数据,才能查写sql才返回按code分组每组load的和并且,re列也要在返回列表中呢
程序会提示我说其它列不在group by 子语句中,但是如果我把其它列都加在group by语句中查询结果又不是我所要的啦,它会把所有的纪录都列出来,而不分组计算了
insert into @t select 1 , '001' , 'abc' , 11 , 'asdsdfasdfasdf'
union all select 2 , '002' , 'abc' , 12 , 'asdsdfasdfasdf'
union all select 3 , '001' , 'abc' , 13 , 'asdsdfasdfasdf'
union all select 4 , '002' , 'abc' , 15 , 'asdsdfasdfasdf'
union all select 5 , '001' , 'abc' , 12 , 'asdsdfasdfasdf' select code,sum([load]) as [load],re from @t group by code,re
--这样?