Re: how to query this

[Slackli User]

Thanks all the info.
Just got what I wanted.

2009/9/10 Wolfgang Schaefer <schaewo@stripped>:
> John Daisley schrieb:
>> SELECT MAX(value), id FROM table
>> GROUP BY id;
>>
>>
>>
>
> I guess what Slackli had in mind was more something like this:
> SELECT id, value
> FROM table
> WHERE value = (SELECT max(value) FROM table);