diamond diamond

diamond diamond

  • NA
  • 133
  • 54.4k

Groupby on Datatable with distinct count

Sep 6 2013 11:02 AM
hi,

I have a datatable with some columns. I need the datatable to return the list as below.

Select col1, distinct count(col2) from table1 group by col1.

list of col1 and count of values of col2

Please let me know how to do this.

Thanks in advance.


Answers (1)