ASP.NET 2.0 Question: Download Questions PDF
How do you remove duplicates without using remove duplicate stage?
Answer:
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
delete table tablename where rowid not in Select * from tablename group by column name
Download ASP.NET 2.0 Interview Questions And Answers
PDF