User Tools

Site Tools


kurs:doppelte_zeilen_loeschen
delete from tabelle where id in ( 
  select    b.rowid, b.last_name, b.employee_id 
  from      copy_employees a 
  left join copy_employees b on (b.employee_id = a.employee_id) and (b.rowid > a.rowid) 
  where     (b.rowid is not null) 
)
kurs/doppelte_zeilen_loeschen.txt · Last modified: 2014/09/10 21:22 (external edit)