Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle, query, don't want sort
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)
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