weixin_43728713的博客

selectCOMPNO,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

标题 窗口函数的应用案例insert overwrite ads_self_special_sale_detailselect 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