“KP工作台数据漏斗(二期)”的版本间的差异

来自qingwei personal wiki
跳转至: 导航搜索
投入
投入
第6行: 第6行:
 
<source lang="sql">
 
<source lang="sql">
 
select
 
select
     adm_amt_1d,
+
     stat_date as statDate,
     stat_date
+
     adm_amt_1d as admAmt 
 
from
 
from
     dwp_en_dm_comp_maincatelv2_eff_d  
+
     dwp_en_dm_comp_maincatelv2_eff_d
 
where
 
where
     (stat_date >= "2018-11-01"
+
     (
      and stat_date <= "2018-11-23")
+
        stat_date >= '2018-10-01'         
     and admin_mbr_seq = 14
+
        and stat_date <= '2018-11-23'     
 +
    )    
 +
     and admin_mbr_seq = '14'
 +
order by
 +
    stat_date ASC
 
</source>
 
</source>
  

2018年11月28日 (三) 02:08的版本

描述

https://aone.alibaba-inc.com/req/17899072

二级页面SQL

大盘漏斗

投入

select
    stat_date as statDate,
    adm_amt_1d as admAmt  
from
    dwp_en_dm_comp_maincatelv2_eff_d  
where
    (
        stat_date >= '2018-10-01'          
        and stat_date <= '2018-11-23'      
    )      
    and admin_mbr_seq = '14' 
order by
    stat_date ASC

oneness

external.kpwork.amtDays

select
    ${returnFields}
from
    dwp_en_dm_comp_maincatelv2_eff_d   
where
    ( stat_date &amp;gt;= #{startDate}
       and stat_date &amp;lt;= #{endDate} )
    and admin_mbr_seq = #{adminMemberSeq}