Re: oracle, query, don't want sort

> 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/