MySQL Forums
Forum List  »  Newbie

How does group by algorithm works?
Posted by: Chen Zheng
Date: June 10, 2009 08:58AM

Select A,B,C,sum(D) from table group by A
Also, if I select mutiple columns for a group by statement(as above), for each distinct A, all the value of B must be the same, right?
If not, the query cannot be executed?

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.