On Dec 22, 2011, at 4:08 PM, Paul Sanderson wrote: > I have a large table with some duplicate rows that I want to > delete.
Something along these lines: delete from foo where rowid not in ( select max( rowid ) from foo group by bar, baz ) Adjust as necessary. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users