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: oracle, query, don't want sort

Re: oracle, query, don't want sort

From: tojo <Tojo_at_hotmail.com>
Date: Fri, 15 Apr 2005 13:41:26 +0200
Message-ID: <MPG.1cc9c6cdb7d3f582989708@news.t-online.de>


In article <d3o2dq$omb$1_at_galaxy.uci.agh.edu.pl>, artursiara_at_poczta.onet.pl says...
> > > I have ORDER:
> > >
> > > ROW_NUMBER() OVER
> > > (ORDER BY 'NAME' ASC)
> > > AS rownumber,
> >
> > Which has nothing to do with sorting the output.
>
> why? it's working; I have been testing...
>

You got lucky. Your ORDER BY applies to the partition in your sub- select. Sorting the final output means adding "ORDER BY NAME" to the very end.

Received on Fri Apr 15 2005 - 06:41:26 CDT

Original text of this message

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