Perform Grouping of Resultset in Code
- by NinjaBomb
Stackoverflowers,
I have a resultset from a SQL query in the form of:
Category Column2 Column3
A 2 3.50
A 3 2
B 3 2
B 1 5
...
I need to group the resultset based on the Category column and sum the values for Column2 and Column3. I have to do it in code because I cannot perform the grouping in the SQL query that gets the data due to the complexity of the query (long story). This grouped data will then be displayed in a table.
I have it working for specific set of values in the Category column, but I would like a solution that would handle any possible values that appear in the Category column.
I know there has to be a straightforward, efficient way to do it but I cannot wrap my head around it right now. How would you accomplish it?