![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
BI报表
数据年轮
这个作者很懒,什么都没留下…
展开
-
占位符对时间的掌控
select COMPNO, COMPNM, ORG3NO, ORG3NM, accountname, if(accmm=replace(’selectdate.get(0)′,′−′,′′),currentamount,0)ascurrentamount,if(accmm>if(substr(replace(′{select_date.get(0)}','-',''),current_amount,0) as current_amount, if(accmm>if(substr(rep原创 2020-12-03 09:11:18 · 214 阅读 · 0 评论 -
数据中台之窗口函数应用案例
标题 窗口函数的应用案例 insert overwrite ads_self_special_sale_detail select a2.fourth_daim as COMPNO, a2.fourth_name as COMPNM, a2.third_daim as ORG3NO, a2.third_name as ORG3NM, a2.second_daim as ORG2NO, a2.second_name as ORG2NM, '0' as原创 2020-11-17 10:48:36 · 213 阅读 · 0 评论