kurs:doppelte_zeilen_loeschen
Differences
This shows you the differences between two versions of the page.
|
kurs:doppelte_zeilen_loeschen [2014/09/10 21:22] |
kurs:doppelte_zeilen_loeschen [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | <code> | ||
| + | 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) | ||
| + | ) | ||
| + | </code> | ||
kurs/doppelte_zeilen_loeschen.txt ยท Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
