SQL按照日期分组查询
1. 按照天统计分组
--按照天统计3
select b.data_time,isnull(a.val,0) as val
from (
select convert(varchar(10),dateadd(DAY,number,'2018-08-01'),120) as data_time
from master..spt_values where datediff(DAY,datead...
原创
2018-09-04 16:44:02 ·
23148 阅读 ·
0 评论
关注
分享
扫一扫