ORACLE不熟,估计你是讲查询结果导入到另一个表中 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 ;
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 ;
这个你还是按照版主说的,写出来大家给你看看
或者贴出示范表格和想要达到的效果,直接写比较合适
oracle没玩过,也不清楚oracle函数的意思,没法给你翻译成MYSQL语句