--按mySql语法统计按周,月,季,年。income为合计的价格字段，createDate为交易时间。select sum(income)as revenue,week(createDate) as week,month(createDate) as month,quarter(createDate)as quarter,year(createDate)as year from employeewhere year(createDate) >= ‘2006‘ group byweek(createDate),month(createDate),quarter(createDate),year(createDate) --sqlserver2005语法统计按周,月,季,年。--按日--select sum(price),day([date]) from table_name where year([date]) =‘2006‘ group by day([date])--按周quarterselect sum(price),datename(week,price_time) from ble_name whereyear(price_time) = ‘2008‘ group by datename(week,price_time)--按月select sum(price),month(price_time) from ble_name where year(price_time)= ‘2008‘ group by month(price_time)--按季select sum(price),datename(quarter,price_time) from ble_name whereyear(price_time) = ‘2008‘ group by datename(quarter,price_time)--按年select sum(price),year(price_time) from ble_name whereyear(price_time) >= ‘2008‘ group by year(price_time)