This shows you the differences between two versions of the page.
kurs:doppelte_zeilen_loeschen [2014/09/10 21:22] (current)
|Line 1:||Line 1:|
|+||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)|