Duplicate records

Deven Oza

I have a table with duplicate records and I want to delete one set of records from this table. is there any function which I can use in remove this dups from table.

thanks,
Deven

Nov 26 '08 #1

ck9663

@Deven Oza
If it's a full duplicate (all columns are the same), use SELECT... DISTINCT... INTO...a new table.

Up to you if you either:
1. truncate your table
2. insert from newly created one.

or

1. drop your table
2. rename the newly created table.

Happy coding!


-- CK

Nov 27 '08 #2