Hi Neel,

Could you provide some more details please?

1. What version SQL Server?

2. Table definition (table name, column names, data types, keys, indexes)?

3. Some sample data rows

4. What exactly do you mean by duplicate rows? If three rows are duplicates do you want to delete all of them, the first two or the last two? There are many postings on this site about eliminating duplicate rows.

5. Is this a once-off request or do you want to run this regularly?

PeterL