MySQL Forums :: Newbie :: How does group by algorithm works?


Advanced Search

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


Subject Written By Posted
How does group by algorithm works? Chen Zheng 06/10/2009 08:58AM
Re: How does group by algorithm works? laptop alias 06/10/2009 09:38AM
Re: How does group by algorithm works? Peter Brawley 06/10/2009 09:41AM
Re: How does group by algorithm works? Chen Zheng 06/10/2009 12:59PM
Re: How does group by algorithm works? Peter Brawley 06/10/2009 01:42PM
Re: How does group by algorithm works? Rick James 06/11/2009 11:40PM
Re: How does group by algorithm works? Chen Zheng 06/12/2009 08:43AM
Re: How does group by algorithm works? Rick James 06/12/2009 09:12AM
Re: How does group by algorithm works? Chen Zheng 06/12/2009 09:29AM
Re: How does group by algorithm works? Rick James 06/12/2009 09:37AM
Re: How does group by algorithm works? Chen Zheng 06/12/2009 10:50AM


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.