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

Reply via email to