John Daisley schrieb: > SELECT MAX(value), id FROM table > GROUP BY id; > > Regards > > John Daisley > Mobile +44(0)7812 451238 > Email j...@butterflysystems.co.uk > > Certified MySQL 5 Database Administrator (CMDBA) > Certified MySQL 5 Developer > Cognos BI Developer > > ----------------------- > Sent from HP IPAQ mobile device. > >
I guess what Slackli had in mind was more something like this: SELECT id, value FROM table WHERE value = (SELECT max(value) FROM table); cheers, wolfgang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org