分组统计的简单问题

[kkobebryant]

表: ID debit credit date
1 8.0 9.0 20051011
2 4.0 5.6 20051012
3 2.0 3.6 20051011

我要的查询结果:
ID debit credit date
1 8.0 9.0 20051011
3 2.0 3.6 20051011
合计 10.0 12.6
2 4.0 5.6 20051012
合计 4.0 5.6

请问这个SQL语句怎么写????????其实就是按日期分组统计

[txlicenhe]

create table tb(id int,debit numeric(6,1),credit numeric(10,2),date char(8))
insert tb select 1,8.0,9.0,'20051011'
union all select 2,4.0,5.6,'20051012'
union all select 3,2.0,3.6,'20051011'


select id,debit,credit,date1 from
(
select cast(id as varchar) id,debit,credit,date,date date1 from tb
union all
select '合计',sum(debit),sum(credit),date,''
from tb
group by date
) aa
order by date,id

呵呵，显示结果完全一样。

[zlp321002]

select id=case when grouping(id)=1 and grouping(date)=1 then '总计'
when grouping(id)=1 then date+':合计'
else convert(varchar(10),id) end,
debit=sum(debit),
credit=sum(credit),
date=isnull(date,'')
from @t
group by date,id
with rollup

[bitliuyang]

debit credit date
*********************
select id,sum(debit),sum(credit) from 表 group by date

[kubou]

up

[SQL147]

select id,debit,credit,date
from tb1
order by date
compute sum(debit),sum(credit) by date