User107

User107

  • NA
  • 28
  • 17.6k

how to filter duplicate records in multiple columns asp.net

Sep 13 2016 5:05 AM

In my web application, i need to filter duplicate records in multiple columns.

I tried code:

select distinct col1,col2,col3 from collection
            
select col1,col2,col3 from collection Group By col1,col2,col3

I need to remove duplicate rows in col1,col2 and col3.
I tried with Group By keyword also but it displayed all duplicates also.

can anyone please tell how to do this.

Thank you

 

Answers (2)