Re: Eliminating duplicates

: >Is there a way to remove duplicate records from a table? I did an
: >import from a backup three times, and I didn't realize that each time
: >it would add in another copy of a record. I can't go back to the
: >backup because new data has been added since then.
 

: Sorry, my last message was incomplete
 

: After the select, then for each record you want to delete do
 

: delete from table
: where rowid = "the row id of the select";

Your solution is still a little incomplete, Try using this:

	delete from <table><alias>
	  where rowid > (select min(rowid)
			 from <same table as above>
			   where <pk column> = <alias>.<pk column>;