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

Home -> Community -> Usenet -> c.d.o.misc -> Re: selecting a column according to a minimum

Re: selecting a column according to a minimum

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 19 Oct 2004 22:41:56 -0700
Message-ID: <1098250865.789933@yasure>


Serge Rielau wrote:

> Daniel here is the relevant quote from the original post:
> >How can I rewrite the SELECT statement in (1) such that [condition]
> >doesn't have to be typed in twice? Or how can I achieve the same thing
> >in some other way? (I am open to other solutions as well as long as
> >they are inside the limits of Oracle PL/SQL.)
> The proposed syntax works, to the best of my knowledge, in Oracle 9i and
> it does answer the post.
> I try to help with SQL issues across newsgroups for DB2, Informix, SQL
> Server and on occasion Oracle.
> IBM policy does not allow me - a DB2 engine developer - to install a
> competitive product. The reasons for that are obvious: It would invite
> lawsuits. Just read the Oracle licencing agreement if you doubt that.
>
> Not having a specific product installed is not a hindrance to contribute
> SQL Standard knowledge.
>
> If you have an issue with my constructive posts in this group just hit
> the ignore button on your reader.
>
> Cheers
> Serge

Not at all ... I like having you here. But rather than saying you don't know Oracle syntax I am suggesting you install it and learn it. I will personally donate time to that end if you are willing.

You can download a free copy at http://otn.oracle.com or purchase the demo CD pack at http://store.oracle.com for less than $70USD.

And, of course, the syntax help you need can be found at http://tahiti.oracle.com and in Morgan's Library at http://www.psoug.org.

Come on down and take a test drive.

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Oct 20 2004 - 00:41:56 CDT

Original text of this message

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