MERGE INTO user_member_info a
USING ( select min(UP.created) as cre,min(up.shop_no) as shop_no,up.memberid as memberid
from user_platform_relation up,
( select memberid as mid,min(created) as cre
from user_platform_relation
group by memberid) um
where up.created = um.cre and up.memberid = um.mid
group by up.memberid) b
ON (a.id = b.memberid
)
WHEN MATCHED THEN UPDATE SET a.created = b.cre,a.shop_no = b.shop_no,a.modified_time = sysdate
where a.shop_no is null;
如对本文有疑问, 点击进行留言回复!!
Oracle Dataguard故障转移(failover)操作
Oracle之 LISTAGG () OVER(PARTITION BY)函数
Oracle查询用户,表结构,表索引,存储过程,触发器等信息整理
oracle的自连接、内连接、外连接、交叉连接、自然连接、等值连接、不等值连接
Oracle数据库使用replace函数批量删除数据中的双引号
网友评论