View Full Version : I want to delete duplicate records from a table


k.goutam08
05-29-2008, 01:39 AM
HI experts,

I want to delete the duplicate records from a table, so is there any query available in sqlserver?

georgedwilkinson
05-29-2008, 07:03 AM
How will you know which record to keep?

Take a look at using "Count(*)" as your criteria.