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

Popular posts from this blog

magento2 - Magento 2 admin grid add filter to collection -

Android volley - avoid multiple requests of the same kind to the server? -

Combining PHP Registration and Login into one class with multiple functions in one PHP file -