Re: Urgent help
From: Bob Badour <bbadour_at_golden.net>
Date: Mon, 28 Jul 2003 10:29:34 -0400
Message-ID: <6rbVa.1354$gN1.246381621_at_mantis.golden.net>
Date: Mon, 28 Jul 2003 10:29:34 -0400
Message-ID: <6rbVa.1354$gN1.246381621_at_mantis.golden.net>
"Alan" <alanpltse_at_yahoo.com.au> wrote in message
news:3f24c465_at_news.comindico.com.au...
> OR I should simplify my problem :
>
> BucketID Time WaterLevel
> ------------------------------------------
> 1 9:00 Empty
> 1 10:00 Half
> 1 11:00 Full
> 2 9:20 Empty
> 2 10:00 Full
>
> The BucketID is primary key. The timing of all buckets are random, so the
> time of bucket 2 'full' may be earlier than bucket 1. That's why I don't
> understant why to use the MAX aggregate function.
Since you are grouping by bucketID, the amounts for different buckets are never compared. Received on Mon Jul 28 2003 - 16:29:34 CEST