Re: oracle, query, don't want sort

Artek Siara wrote:
> 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
>
>

I don't see a sort, do you?
select * from (....) where rownumber >= 1 and rownumber <=3 (odd where clause, btw)

-- 
Regards,
Frank van Bortel