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.