DB2 merge into 备忘

最新推荐文章于 2019-06-14 21:00:56 发布

shininghunter

最新推荐文章于 2019-06-14 21:00:56 发布

阅读量309

点赞数

分类专栏： DB2

本文链接：https://blog.csdn.net/shininghunter/article/details/15338279

版权

DB2 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

merge into session.EMPLOYE as EM
using (select MA.managerid,MA.name,MA.salary from session.MANAGER as MA where MA.managerid = 6) as MA
on EM.employeid = MA.managerid
when matched and EM.salary < MA.salary then update set EM.salary = MA.salary
when matched and EM.salary > MA.salary then delete
when not matched then insert values (MA.managerid,MA.name,MA.salary)
else ignore;