203923

delete from d_fn_register_mo3 mo3
where mo3.ID in (select case when t.id = max(t.id) over(partition by id_nci,
oid,
namefull,
nameshort,
kpp,
ogrn,
inn,
organizationtype,
parentid,
founder,
deletedate,
regionid,
medicalsubjectid,
oldoid,
createdate,
modifydate,
deletereason,
medicalsubjectname,
regionname,
modeptname,
molevelid,
moagencykind,
profileagencykind,
vers) then null else t.id end id
 from d_fn_register_mo3 t)