Deleteing duplicate records from my table

[Bill]

I just discovered that all my records appear twice inside my table, in
other words, they repeat on the row below. How can I delete all of the
duplicates? I'm sure there must be a tidy line of sql to do that.

Thanks,

Bill

[Jonathan Levy]

Re: Deleteing duplicate records from my table

billzimmerman@g ospellight.com (Bill) wrote in message news:<8da5f4f4. 0307310856.7983 0a8e@posting.go ogle.com>...[color=blue]
> I just discovered that all my records appear twice inside my table, in
> other words, they repeat on the row below. How can I delete all of the
> duplicates? I'm sure there must be a tidy line of sql to do that.
>
> Thanks,
>
> Bill[/color]

Maybe run a select distinct query and insert the results into a new
table? If need be, you could then delete all records from your
original table and insert the records back.

That should be reasonably tidy but it is hard to say what the
performance would look like without knowing the specifics.