Re: Confused by max and group by

[Brent Baisley]

The problem you are running into is that you are getting the max of one 
field and grouping by another. But then you want to get a third field 
that changes within the grouping.
Perhaps this might work
    SELECT myindex, myval, mycat
    FROM `mytest`
    GROUP BY mycat
    ORDER BY myindex DESC;

On Apr 21, 2004, at 4:47 PM, Noah Spurrier wrote:

Unfortuantely, that didn't do it. I tried both DESC and ASC.
I got the same incorrect result. This is too bad. It SEEMS like it 
should work...

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]