Oracle ±Ê¼Ç

ɾ³ýÖظ´Êý¾Ý£¬Ö»±£Áô1Ò»Ìõ

delete from (select *
from tbl_user_authority a
where (a.user_account, a.dept_code) in
(select b.user_account, b.dept_code
from tbl_user_authority b
group by b.user_account, b.dept_code
having count(*) > 1)
and rowid not in (select min(rowid)
from tbl_user_authority c
group by c.user_account, c.dept_code
having count(*) > 1)
order by a.user_account, a.dept_code)

×Ô¶¯Ìî³ä update select

update tbl_cerecord_base t
set t.service_unit_name =
(select tt.name
from tbl_service_unit tt
where t.service_unit = tt.code
and t.responsible_dept = tt.dept_code)