-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 12:17 AM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Erroneus column using MAX() and GROUP BY
You've misunderstood how GROUP BY and MAX() work. GROUP BY divides your
data into groups, and aggr
You've misunderstood how GROUP BY and MAX() work. GROUP BY divides your
data into groups, and aggregate functions such as MAX() tell you something
about each group, but they *do not* return *rows* from your table. Consider
the following example rows in a larger table:
cat val1 val2
4