SQL按照日、周、月、年统计数据的方法
本文导语: SQL按照日、周、月、年统计数据的例子，如下： 代码示例: --按日 select sum(consume),day([date]) from consume_record where year([date]) = '2013' group by day([date]) --按周quarter select sum(consume),datename(week,[date]) from consume_record where year([date]) = '...
SQL按照日、周、月、年统计数据的例子，如下：
--按日
select sum(consume),day([date]) from consume_record where year([date]) = '2013' group by day([date])
--按周quarter
select sum(consume),datename(week,[date]) from consume_record where year([date]) = '2013' group by datename(week,[date])
--按月
select sum(consume),month([date]) from consume_record where year([date]) = '2013' group by month([date])
--按季
select sum(consume),datename(quarter,[date]) from consume_record where year([date]) = '2013' group by datename(quarter,[date])
--按年
select sum(consume),year([date]) from consume_record where group by year([date])
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。