Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle, query, don't want sort
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.