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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
