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: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 14 Apr 2005 08:27:17 -0700
Message-ID: <1113492209.141658@yasure>


Artek Siara wrote:

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

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

>
>
> I have ORDER:
>
> ROW_NUMBER() OVER
> (ORDER BY 'NAME' ASC)
> AS rownumber,
>
> regards,
> Artur

Which has nothing to do with sorting the output.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Apr 14 2005 - 10:27:17 CDT

Original text of this message

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