14-02-2012, 01:16 PM
لديا قاعدة بيانات و أحذف المتكررات بهذه الطريقة ,الجدول يسمى ASSURE01
delete from assure01 t where t.nass in (select distinct nass from assure01 group by nass
having count(*) > 1
delete from assure01 t where t.nass in (select distinct nass from assure01 group by nass
having count(*) > 1

