56,675
社区成员
发帖
与我相关
我的任务
分享
delimiter $$
create procedure p_t_userdayInc
begin
insert into t_r_userInc_day(day,incCount,t_incCount,channelid,deviceId,state)
select
trunc(sysdate -1) as day,
count(distinct userId) as incCount,
count(distinct userId) as t_incCount,
decode(grouping_id(channelid),1,'0',channelid) as channelid,
decode(grouping_id(deviceId),1,'0',deviceId) as deviceId,
0
from t_payplatform_user
where createtime >= trunc(sysdate-1)
and createTime < trunc(sysdate)
group by rollup(channelid,deviceId) ;
end ;
$$
delimiter ;