日期返回1号并聚合
2021-03-26 本文已影响0人
BI罗
select cast( CONVERT(varchar(100), DATEADD(mm,DATEDIFF(mm,0,f.[date]),0), 23) as date) as YM ,f.Banner as banner,SUm(f.TY) as ty
FROM
test_fact as f
left join
vbanner as b
on f.Banner=b.banner
where
f.[date]<=b.[date]
GROUP BY
cast( CONVERT(varchar(100), DATEADD(mm,DATEDIFF(mm,0,f.[date]),0), 23) as date) ,
f.Banner
