DELETE
delete from ( select * from employees2 where department_id=90);
UPDATE
update ( select e1.salary,e2.salary new_sal
from employees e1,employees2 e2
where e1.emp_id=e2.emp_id)
set salary=new_sal;
INSERT
insert all
when sum_orders <10000 then
into t1
when sum_orders >=10000 and sum_orders<20000 then
into t2
else
int t3
select customer_id,sum(order_total) sum_orders
from oe.orders
group by customer_id
MERGE
merge into t1 b
using(
select tmp_id,salary,department_id from employees where dep_id=60) e
on (b.emp_id=e.emp_id)
when matched then
update set b.col2=e.col2*0.2 where b.col1=0
delete where (e.col3>7000)
when not matched then
insert (b.emp_id,b.bonus_amt) values (e.tmp_id,e.salary*0.1)
where (e.salary<7500)