Counting and showing Duplicates in DataTable vb.net -


i having issues trying count / show duplicate records in datatable.

for example have datatable multiple columns.

eg

item (colum1) |  111  112  113  111  112  112  112  114 

i want try , create datatable form outputs following

item (colum1) | counter (colum2)  111             2  112             4  113             1  114             1 

so query selects results in first column , groups them 1 row per unique item number. second column number of occurrences of item number.

select colum1 item, count(colum1) counter tablename group colum1;


Comments