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: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: Fri, 15 Apr 2005 18:40:52 +0000 (UTC)
Message-ID: <d3p1rk$u78$1@klatschtante.init7.net>


> I have that query:
>
> SELECT * FROM (
>
> SELECT
> ROW_NUMBER() OVER (ORDER BY 'NAME' ASC) AS rownumber,
> ID, NAME, ADDRESS
> FROM system.tab_example
>
> )WHERE rownumber >= 1 AND rownumber <= 3
>
> and I don't know why a result is not sorted ?
> what is wrong?

While others have already pointed out that 'NAME' must actually be either name or "NAME", there is another thing I want to point out: Don't create objects in the system or sys schema.

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/
Received on Fri Apr 15 2005 - 13:40:52 CDT

Original text of this message

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