Re: oracle, query, don't want sort

From: Artek Siara <artursiara_at_poczta.onet.pl>
Date: Thu, 14 Apr 2005 13:44:35 +0200
Message-ID: <d3ll32$pm8$1@galaxy.uci.agh.edu.pl>

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