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: Alan <alanpltse_at_yahoo.com.au>
Date: Fri, 25 Jul 2003 04:32:38 GMT
Message-ID: <3f20b2e5@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 Thu Jul 24 2003 - 23:32:38 CDT












Original text of this message













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