一、查询某一年的每月汇总数据
SELECT CONVERT(CHAR(7), FinishDate,120) as FinishDate, SUM(Amount) as Amount,convert(varchar,100*SUM(Amount)/65000000)+‘%‘ as Ratio FROM Consignment where year(FinishDate)=2015 GROUP BY CONVERT(CHAR(7), FinishDate,120) order by FinishDate
原文：http://www.cnblogs.com/zhoujiahong/p/6489839.html