On 17 Aug 2009, at 8:31am, Gilles Ganault wrote: > I have a table that has a lot of duplicates in the Name column. I'd > like to only keep one row for each. > > The following lists the duplicates, but I don't know how to delete the > duplicates and just keep one: > > SELECT name FROM members GROUP BY name HAVING COUNT(*) > 1;
The sort of thing you're looking for is SELECT DISTINCT name FROM members; but I don't know if that particular command gives the result you're looking for. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
