欢迎投稿

今日深度:

oracle中多表联合修改效率快的修改语句分享,o

oracle中多表联合修改效率快的修改语句分享,oracle语句


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;

www.htsjk.Com true http://www.htsjk.com/oracle/24394.html NewsArticle oracle中多表联合修改效率快的修改语句分享,oracle语句 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 memberi...
评论暂时关闭