From: Claudio Nanni
Date: September 10 2009 3:14pm
Subject: Re: how to query this
List-Archive: http://lists.mysql.com/mysql/218688
Message-Id: <53bcf3a60909100814w2680e6c0r1c91af45872f4385@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001485e36bef314b1604733aa9d7

--001485e36bef314b1604733aa9d7
Content-Type: text/plain; charset=ISO-8859-1

This can also help:

select id,value from table order by value desc limit 1;


Cheers

Claudio


2009/9/10 Slackli User <slackliuser@stripped>

> 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);
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@stripped
>
>


-- 
Claudio

--001485e36bef314b1604733aa9d7--