Oracle、Hive 统计三个月,六个月,九个月,十二个月的平局值
下面为统计截止2020-06-30,近三个月,六个月,十二个月的平均值直接上代码select * from (select a.cust_id, '2020-06-30' as dt1, a.dt, avg(val)over(partition by cust_id order by dt desc) thr_mon_avg, row_number()over(partition by cust_id order by dt desc) sequ