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: [Beginner] Problem with Order by of a date

Re: [Beginner] Problem with Order by of a date

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Tue, 8 Nov 2005 21:56:22 +0000 (UTC)
Message-ID: <dkr6u6$s9d$1@nntp.init7.net>


> -- This is better because in the inner select, it
> -- orders a descending and assigns a value to r.
> -- This value starts with 1 and is incremented by
> -- 1 for each row.
> -- The outer select then selects the (desired) row
> -- whose r = 1.

Reading my own post, I realize that I have chosen two bad column names in the sample script. The sentence above should read:

  This is better because in the inner select, it   orders THE COLUMN a descending and assigns a value to r.

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/
Received on Tue Nov 08 2005 - 15:56:22 CST

Original text of this message

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