日期分组统计问题?

Question

2005-10-03
2005-10-12
2005-11-03
2005-11-12
2005-11-13
2005-10-15
2005-11-11
2005-11-12
2005-11-09
以上日期,我想按年月进行分类汇总,请叫了?

Answer 1

select sum(datafield),month(dateField),year(DateField) from TableName group by month(dateField),year(DateField)

Answer 2

select sum(datafield),year(DateField) from TableName group by year(DateField)

Answer 3

日期          金额
2005-10-03    100
2005-10-12    200
2005-11-03    150
2005-11-12    300
2005-11-13    123
2005-10-15    111
假设数据是这样的
Select Left(日期,7) as 月份,Sum(金额) as 金额合计 From mTable Group by Left(日期,7)

Answer 4

... Group by Left(日期,7)

Answer 5

select sum(otherfield) from TableName group by year(DateField),month(dateField)