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: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 14 Apr 2005 13:44:05 +0200
Message-ID: <d3lkrh$oso$2@news4.zwoll1.ov.home.nl>


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
Received on Thu Apr 14 2005 - 06:44:05 CDT

Original text of this message

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