ASP.NET 2.0 Interview Question:

How do you remove duplicates without using remove duplicate stage?

Submitted by: Administrator

In the target make the column as the key column and run the job.


delete table tablename where rowid not in Select * from tablename group by column name
Submitted by: Administrator