Re: how to query this

[Wolfgang Schaefer]

John Daisley schrieb:
> SELECT MAX(value), id FROM table
> GROUP BY id;
>
> Regards
>
> John Daisley
> Mobile [phone]
> Email john@stripped
>
> 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