SQL按照日、周、月、年统计数据

写sql语句分别按日，星期，月，季度，年统计销售额 –按日 select sum(consume),day([date]) from consume_record where year([date]) = ‘2006’ group by day([date]) –按周quarter select sum(consume),datename(week,[date]) from consume_record where y

写sql语句分别按日，星期，月，季度，年统计销售额

–按日
select sum(consume),day([date]) from consume_record where year([date]) = ‘2006’ group by day([date])

–按周quarter
select sum(consume),datename(week,[date]) from consume_record where year([date]) = ‘2006’ group by datename(week,[date])

–按月
select sum(consume),month([date]) from consume_record where year([date]) = ‘2006’ group by month([date])

–按季
select sum(consume),datename(quarter,[date]) from consume_record where year([date]) = ‘2006’ group by datename(quarter,[date])

–按年

sel本文来源gaodai$ma#com搞$$代**码)网@ect sum(consume),year([date]) from consume_record where group by year([date])

，

搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：SQL按照日、周、月、年统计数据

Hi，您需要填写昵称和邮箱！