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. -----Original Message----- From: Slackli User <slackliu...@gmail.com> Sent: Thursday, September 10, 2009 10:43 AM To: mysql@lists.mysql.com Subject: how to query this Hello, sorry I'm not good at SQL statement. I have a table, whose stru is like: id value 1 33 2 987 3 10 4 22 ... I want to get the max value and the corresponding id, using this sql: select max(value),id from table; but it won't work. so what's the correct syntax? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org