MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: sum, group by, union
Posted by: Felix Geerinckx
Date: April 07, 2005 01:34PM

Chris Stubben wrote:

> That should be easy. Just multiply the sum by the
> number of rows (Count or *). If the count is 1
> the sum doesn't change. I don't think you need
> subqueries in this case.

Did you actually test this on actual data?

--
felix

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
sum, group by, union
vanessa vercruysse
April 06, 2005 12:47AM
Re: sum, group by, union
Chris Stubben
April 06, 2005 11:02AM
Re: sum, group by, union
vanessa vercruysse
April 07, 2005 12:14AM
Re: sum, group by, union
Felix Geerinckx
April 07, 2005 05:45AM
Re: sum, group by, union
Chris Stubben
April 07, 2005 10:25AM
Re: sum, group by, union
Felix Geerinckx
April 07, 2005 01:34PM
Re: sum, group by, union
Chris Stubben
April 07, 2005 03:40PM
Re: sum, group by, union
vanessa vercruysse
April 08, 2005 12:05AM


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.