22,300
社区成员




select RefName,Mat,Max(Date) as Date ,sum(Many) as Many from @galenkeny group by RefName,Mat
declare @galenkeny table( Date datetime, RefName varchar(20),Mat varchar(20), Many int )
insert into @galenkeny
select '2014-6-1' ,'小张' , '电视机',10 union all
select '2014-6-2' ,'小张' , '电视机',20 union all
select '2014-6-3' ,'小王' , '手机',5 union ALL
select '2014-6-3' ,'小里' , '手机',15
select a.RefName,a.Mat,a.Many ,b.Date from
(select RefName, Mat,sum(Many) as Many from @galenkeny group by RefName,Mat)
a left join
(select RefName,Mat,Max(Date) as Date from @galenkeny group by RefName,Mat)
b on a.Mat=b.Mat and a.RefName=b.RefName