On Wed, 15 Nov 2006, r937 wrote: > this could only have come up in mysql, by the way > > writing this (which is what you had) -- > > select a, b, c, count(*) ... group by a, b > > is invalid in all other databases > > you will find that in the result set, there will be one row for each > combination of a,b, but the value for c in the results is unpredictable
If I understand right, you're saying that using an aggregating function on a field you haven't included in the GROUP BY clause is illegal in "real" databases, and unpredictable in MySQL (like most things in MySQL ;) )? That's definately one worth remembering, thanks! Cheers Dave P ____ The WDVL Discussion List from WDVL.COM ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
