求时间段成交额查询sql语句

[ICADCS]

数据库数据如下：
时间 成交额
Time money
2010-09-01 10:28:22 2232
2010-09-01 12:44:23 6767
2010-09-01 16:55:22 664
2010-09-02 13:31:20 1232
2010-09-02 13:11:05 1000
。。。
。。。
2010-09-30 12:32:55 1231
。。。
...
2011-03-10 09:50:44 3424
想查询2010年某个月每天的成交总量，以及2010年12个月成交总量，大致意思就是按天汇总，或者按月汇总sql语句怎么写呢

[快溜]

--按天
select convert(varchar(10),[Time],120) as 日期,sum([money]) from tb group by convert(varchar(10),[Time],120)
--按月
select month([time]) as 月,sum([money]) from tb where year([time])=2010 group by month([time])

[AcHerat]

select convert(varchar(10),[time],120) [天],sum([money]) [money],
      (select sum([money]) from tb where convert(varchar(7),[time],120) = convert(varchar(7),t.[time],120)) [月]
from tb t
group by convert(varchar(10),[time],120)

[小童]

select convert(varchar(10),[time],120) [天],sum([money]) [money],
      (select sum([money]) from tb where convert(varchar(7),[time],120) = convert(varchar(7),t.[time],120)) [月]
from tb t
group by convert(varchar(10),[time],120)

[lijian8552]

select sum(money) as 总成交额 from money where time between '2011-03-18 00:00:00' and '2011-03-19 00:00:00'

前后分别是开始时间和结束时间

[liang145]

declare @YM nvarchar(10)     --求单月的
set @YM='2010-09'
select sum(成交额)as @YM from #TP where convert(nvarchar(7),时间,120)=@YM

declare @Y nvarchar(4)         --求一年中12个月分组的
set @Y='2010'
select convert(nvarchar(7),时间,120) as 月份, sum(成交额) as [SUM] from #TP where convert(nvarchar(4),时间,120)=@Y
group by convert(nvarchar(7),时间,120)