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?
thanks for help
regards, Artur Received on Thu Apr 14 2005 - 05:51:38 CDT