新增投资人数

Teresa7

于 2017-04-25 21:19:19 发布

阅读量651

点赞数

分类专栏： Development

本文链接：https://blog.csdn.net/Angelina7/article/details/70767438

版权

Development 专栏收录该内容

45 篇文章 2 订阅

订阅专栏

投资元数据

 create table  t (custac varchar2(20),trandt varchar2(8),channel_cd varchar2(8) )
insert into t values ('6000492298','20170412','90001');
insert into t values('6000492298','20170412','90001');
insert into t values('6000488758','20170414','90001');
insert into t values('6000492256','20170413','90001');
insert into t values('6000497764','20170417','90001');
insert into t values('6000492298','20170417','90001');
insert into t values('6000492298','20170417','90002');
commit;

计算每个渠道每天新增的投资人。
select count(distinct custac) cnt, channel_cd, trandt
  from (select custac,
               channel_cd,
               trandt,
               row_number() over(partition by channel_cd, custac order by trandt) rn
          from t)
 where rn = 1
 group by channel_cd, trandt