Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Urgent help

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@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 - 09:29:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US