On Mon, 17 Aug 2009 13:05:53 +0200, Martin Engelschalk <[email protected]> wrote: >If you are looking for a delete - command, then you have to decide which >of the duplicate rows you want to keep. Are they all the same even in >the other fields? > >Perhaps you want to do something like > >delete from members where exists (select rowid from members m2 where >m2.name = members .name and m2.rowid < members .rowid) > >This statement deletes all rows where there exists a row with the same >name and a lowe rowid. Rowid is an internal field of sqlite.
Thanks for the code :) _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
