17,377
社区成员
发帖
与我相关
我的任务
分享
MERGE INTO games_data b
using (select sub_id, game_name, registe_date, rn
from (select sub_id,
game_name,
a.registe_date,
row_number() over(partition by game_name, sub_id, trunc(registe_date) order by sub_id, registe_date) as rn
from game_user_details a
where trunc(registe_date) = trunc(sysdate))
where rn = 1) c
on (trunc(b.DATE1) = trunc(c.registe_date))
WHEN MATCHED THEN
update set b.site_id = c.sub_id, b.date1 = c.registe_date
WHEN NOT MATCHED THEN
insert (site_id, date1) values (c.sub_id, c.registe_date)
MERGE INTO games_data b
using (select sub_id, game_name, registe_date, rn
from (select sub_id,
game_name,
a.registe_date,
row_number() over(partition by game_name, sub_id, trunc(registe_date) order by sub_id, registe_date) as rn
from game_user_details a
where trunc(registe_date) = trunc(sysdate))
where rn = 1) c
on (trunc(b.DATE1) = trunc(c.registe_date))
WHEN MATCHED THEN
update set b.site_id = c.sub_id
WHEN NOT MATCHED THEN
insert (site_id, date1) values (c.sub_id, c.registe_date)
MERGE INTO games_data b
using (select sub_id, game_name, registe_date, rn
from (select sub_id,
game_name,
a.registe_date,
row_number() over(partition by game_name, sub_id, trunc(registe_date) order by sub_id, registe_date) as rn
from game_user_details a
where trunc(registe_date) = trunc(sysdate))
where rn = 1) c
on 1=1
WHEN MATCHED THEN
update set b.site_id = c.sub_id, b.date1 = c.registe_date
WHEN NOT MATCHED THEN
insert (site_id, date1) values (c.sub_id, c.registe_date)