Link to home
Start Free TrialLog in
Avatar of fred2k3
fred2k3

asked on

How to use Group By in Datasets

I would like to know how I can perform an equivalent search using datasets (i.e. how can I get the same result as using sql?)


SELECT ColumnA, sum( ColumnB )
FROM table
GROUP BY ColumnA
ASKER CERTIFIED SOLUTION
Avatar of Nightman
Nightman
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Fred
I am glad that I was able to help you, but I don't understand why you gave me such a low grade. A C is the lowest grade you can give. Please can you explain this.

Also, please see https://www.experts-exchange.com/help.jsp#hi73 - "What's the right grade to give".
Avatar of fred2k3
fred2k3

ASKER

In all honestly I didn't feel that you put a lot of effort into explaining the solution since you just posted a link to a site which explained the answer (though not clearly). Having read the guide however, it suggests that a B would have been a more suitable grade.
Fair enough - you can post a question in Community Support to open the question so you can adjust the grade, or wait for the Mods to review this one (I have already posted there) ;)

Usually you will find that when someone posts a long technical link like that it is because it is a good link with lot's of detailed information. Because we already assume a strong base understanding from the asker (especially in an area like C#), we expect that if there are any technical questions on specific points in the link (and with this one there could be dozens) that the asker will ask a specific question on implementation, where we can assist.

Some of us have already done this, and have found (after trial and error) a solution that works well. Usually these links are in our archives/favourites - not only are you getting a filtered, targeted Google result, but the potential for an explanation of the code and assistence with implementation.

Of course this doesn't always apply - there are some posters on this site (not all posters are really experts!) that simply use Google for solutions they don't understand themselves. You will have to evaluate these answers for yourself and decide whether the 'expert' answer deserves anything better than a B. C is usually 'that was a terrible answer!'.

At the same time, 'No, you can't do that' is also an answer, and sometimes a good one and deserves an A (see your question https://www.experts-exchange.com/questions/22065618/Specifying-auto-number-seed-and-step-values-in-MySql-when-using-the-Create-Table-command.html) - just because it's not what you want to hear doesn't mean it's wrong.

I hope this explains a bit more - and I also hope that I don't sound like I was lecturing (not the intention, I just want to clarify).

Cheers
Night