Re: how to query this

This can also help: select id,value from table order by value desc limit 1; Cheers Claudio 2009/9/10 Slackli User > Thanks all the info. > Just got what I wanted. > > 2009/9/10 Wolfgang Schaefer : > > John Daisley schrieb: > >> SELECT MAX(value), id FROM table > >> GROUP BY id; > >> > >> >

Re: how to query this

Thanks all the info. Just got what I wanted. 2009/9/10 Wolfgang Schaefer : > 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

Re: how to query this

John Daisley schrieb: > 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 > > --- >

RE: how to query this

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. -Origina

Re: how to query this sql?

On Sun, April 29, 2007 05:28, Jeff Pang wrote: > Hello list, > > I want to get the counter for db-items by each day,so I wrote this sql: > > select count(*) as dd from items group by updatetime; > > But sorry "updatetime" is "datetime" type,not "date" type.Then I can't get > the correct result. >