表内容:
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,
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
