Re: Urgent help
From: Alan <alanpltse_at_yahoo.com.au>
Date: Fri, 25 Jul 2003 04:32:38 GMT
Message-ID: <3f20b2e5_at_news.comindico.com.au>
Date: Fri, 25 Jul 2003 04:32:38 GMT
Message-ID: <3f20b2e5_at_news.comindico.com.au>
Cim,
Sorry, could you tell me why do I need to use the max please ?
"Cimarron Taylor" <cimarron+google_at_taylors.org> wrote in message
news:29e28c51.0307241531.7aee525c_at_posting.google.com...
> If you enforce some additional constraints about the content
> of the table you could consider using an aggregate expression
> such as max(IF(WaterLevel='Empty', Time, '')) along with
> group by BucketId.
>
> Cim
Received on Fri Jul 25 2003 - 06:32:38 CEST