要求根据给定日期,对本月与上月数据进行计算。
SQL记录:
select tb.[name],tb.x,round(tb.x/tb.y*100,2) as result from
(select a.[name],a.x,b.y from
(select [name],[数值1] as x from test where date_param>='2020-10-01' and date_param<'2020-11-01') a
left join
(select [name],[数值1] as y from test where date_param>=DATEADD(mm, -1, '2020-10-01')
and date_param<DATEADD(mm, -1, '2020-11-01')) b
on a.name=b.name) tb
欢迎关注wx公众号:python web小栈,共同探讨学习