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: Cimarron Taylor <cimarron+google_at_taylors.org>
Date: 25 Jul 2003 14:45:16 -0700
Message-ID: <29e28c51.0307251345.96a9a7e@posting.google.com>


> > order by BucketID
> Did you mean "group by"?

Yes - "order by" is a mistake.

> > For example, could the table contain the following data and how
> > would you want it presented?
>
> This was not a part of the original problem. Anybody able to write a query
> in "clean" scenario, could amend it to handle nulls.

Correct. However my "sample" data did not include nulls -- just a few empty character columns. If you include nulls, it increases the likelyhood that that the max() expression I proposed will not return the desired result.

This is another reason to start with a clear statement of assumptions about the input and output data.

Cim Received on Fri Jul 25 2003 - 16:45:16 CDT

Original text of this message

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