位置: sql按照日期范围查询 - 标签
SQL按照日、周、月、年统计数据的方法分享(sql按照日期范围查询)
简述:--按日selectsum(consume),day([date])fromconsume_recordwhereyear([date])=''groupbyday([date])--按周quarterselectsum(consume),datename(week,[date])fromconsume_recordwhereyear([date])=''groupbydatenam