Re: MySQL SQL Query Help

[Niel Archer <niel@xxxxxxxxxxxxx>]

Hi 

Try:

SELECT fkid, MAX(foo), bar FROM table GROUP BY fkid ORDER BY bar DESC

Niel

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php