select datepart(year,Datacolumn) as year,sum(xx) as Year_Total from Table group by datepart(year,Datacolumn)
如果还有月份,那就是
select datepart(year,Datacolumn) as Year,datepart(month,Datacolumn) as Month,sum(xx) as Month_Total from Table group by datepart(year,Datacolumn),datepart(month,Datacolumn)