求一sql语句

Question

现在table里有这样的数据：
id   time         num1    num2
1   2009-01-01    25       89
2   2009-01-02    25       58
3   2009-01-03    23       34
3   2009-02-03    23       134
3   2009-02-04    21       324
3   2009-03-03    21       334
3   2009-03-05    21       314
现在要按time的月份进行求和，如何搞？
time        num1    num2
2009-01     73      181
。。

Answer 1

select convert(char(07),[time],120) as [time],
sum(num1) as num1,sum(num2) as num2
from T
group by convert(char(07),[time],120)

Answer 2

select convert(varchar(7),[time],120) as [time],sum(num1)num1,sum(num2)num2
from tb
group by convert(varchar(7),[time],120)

Answer 3

SELECT LEFT(TIME,7),SUM(NUM1),SUM(NUM2)
FROM TB
GROUP BY LEFT(TIME,7)

Answer 4

select convert(varchar(7),time,120) as time,sum(num1) as num1,sum(num2) as num2
from [tb]
group by convert(varchar(7),time,120) 

Answer 5

select convert(varchar(7),time,120) time , sum(num1) num1 , sum(num2) num2
from table
group by convert(varchar(7),time,120)