sqlÓï¾ä±àд - MS-SQL Server / ÒÉÄÑÎÊÌâ

±íÄÚÈÝ:
date time A B  
2010-04-20 10 1 215
2010-04-20 10 2 50
2010-04-20 11 1 108
2010-04-20 11 2 41
2010-04-20 12 1 118
2010-04-20 12 2 58
2010-04-20 13 1 137
2010-04-20 13 2 50
2010-04-20 14 1 162
2010-04-20 14 2 62
2010-04-20 15 1 252
2010-04-20 15 2 111

ÎÒÒªµÄ±í½á¹ûÊÇÕâÑùµÄ:
date time A=1 A=2
2010-04-20 10 sum(B) sum(B)
2010-04-20 11 sum(B) sum(B)
2010-04-20 12 sum(B) sum(B)
...


ÔõÑùд³ösql Óï¾ä

---

ÏÈͳ¼Æ£¬ºóÁÐתÐÐ

---

SQL code:
create table tb(date datetime,time int,A int,B int)
insert into tb values('2010-04-20', 10 ,1 ,215)
insert into tb values('2010-04-20', 10 ,2 ,50 )
insert into tb values('2010-04-20', 11 ,1 ,108)
insert into tb values('2010-04-20', 11 ,2 ,41 )
insert into tb values('2010-04-20', 12 ,1 ,118)
insert into tb values('2010-04-20', 12 ,2 ,58 )
insert into tb values('2010-04-20', 13 ,1 ,137)
insert into tb values('2010-04-20', 13 ,2 ,50 )
insert into tb values('2010-04-20', 14 ,1 ,162)
insert into tb values('2010-04-20', 14 ,2 ,62 )
insert into tb values('2010-04-20', 15 ,1 ,252)
insert into tb values('2010-04-20', 15 ,2 ,111)
go

select date , time,