用sql语句按周、按月、按季、按年统
浏览数：21 /
时间：2015年06月12日
原文地址：http://hi.baidu.com/%BD%F0%D3%F1kl_y/blog/item/1c368ffba9388476024f5645.html
--按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 employee where year(createDate) >= ‘2006‘ group by week(createDate),month(createDate),quarter(createDate),year(createDate) --sqlserver2005语法统计按周,月,季,年。 --按日 --select sum(price),day([date]) from table_name where year([date]) = ‘2006‘ group by day([date]) --按周quarter select sum(price),datename(week,price_time) from ble_name where year(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 where year(price_time) = ‘2008‘ group by datename(quarter,price_time) --按年 select sum(price),year(price_time) from ble_name where year(price_time) >= ‘2008‘ group by year(price_time)
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
