SQL按照日、周、月、年统计数据
测试表:consume_record
字段1:consume (money类型)
字段2:date (datetime类型)
写sql语句分别按日，星期，月，季度，年统计销售额
--按日
select sum(consume),day() from consume_record where year() = '2006' group by day()
--按周quarter
select sum(consume),datename(week,) from consume_record where year() = '2006' group by datename(week,)
--按月
select sum(consume),month() from consume_record where year() = '2006' group by month()
--按季
select sum(consume),datename(quarter,) from consume_record where year() = '2006' group by datename(quarter,)
--按年
select sum(consume),year() from consume_record wheregroup by year()
页:
[1]