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

来自qingwei personal wiki
跳转至: 导航搜索
(创建页面,内容为“== 描述 == [https://aone.alibaba-inc.com/project/705770/task/17744903?spm=a2o8d.corp_prod_req_detail.0.0.616754d5Gx7pVa aone] category: 阿里 category: 数…”)
 
第1行: 第1行:
 
== 描述 ==
 
== 描述 ==
 
[https://aone.alibaba-inc.com/project/705770/task/17744903?spm=a2o8d.corp_prod_req_detail.0.0.616754d5Gx7pVa aone]
 
[https://aone.alibaba-inc.com/project/705770/task/17744903?spm=a2o8d.corp_prod_req_detail.0.0.616754d5Gx7pVa aone]
 
+
== oneService ==
 +
<source lang="shell">
 +
SELECT
 +
    admin_mbr_seq
 +
FROM
 +
    dwp_en_dm_comp_term_catelv2_eff_d 
 +
where
 +
    stat_date="2018-10-8"
 +
    and statistic_type="day"
 +
    and terminal_type="PC"
 +
    and admin_mbr_seq="14"
 +
    and is_main_cate="Y"
 +
    and cate_lv2_id=123
 +
</source>
 
[[category: 阿里]]
 
[[category: 阿里]]
 
[[category: 数据管家]]
 
[[category: 数据管家]]

2018年11月9日 (五) 06:07的版本

描述

aone

oneService

SELECT
    admin_mbr_seq
FROM
    dwp_en_dm_comp_term_catelv2_eff_d 
where
    stat_date="2018-10-8"
    and statistic_type="day"
    and terminal_type="PC"
    and admin_mbr_seq="14"
    and is_main_cate="Y"
    and cate_lv2_id=123