SELECT MAX(value), id FROM table
GROUP BY id;
Regards
John Daisley
Mobile +44(0)7812 451238
Email john@stripped
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer
-----------------------
Sent from HP IPAQ mobile device.
-----Original Message-----
From: Slackli User <slackliuser@stripped>
Sent: Thursday, September 10, 2009 10:43 AM
To: mysql@stripped
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=1
