Getting List of Duplicate Rows with Unique Multiple Columns - LINQ

[saurabhB]

try this one

How to get duplicate rows for specific column in a datatable

HI @Sunitha_Bist1, Duplicate records from the same data table (From p in dt.Select() where( From q in dt.Select() where string.Join(",",q.ItemArray).Equals(string.Join(",",p.ItemArray)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable() Try this one If you want specific Column alone mention the column name (From p in dt.Select() where( From q in dt.Select() where q("ColumnName").Equals(p("ColumnName")) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable() Regards, Arivu …