Re: Limiting Rows Returned in Query
From: Tony Sollars <vnet35_at_virgin.net>
Date: 1996/11/11
Message-ID: <32874F37.5913_at_virgin.net>#1/1
Date: 1996/11/11
Message-ID: <32874F37.5913_at_virgin.net>#1/1
Joe Nardone wrote:
>>
>> text removed
>>
> Note however that this will not work (correctly) if you use any
> kind of ORDER BY clause; rownum is assigned before that sort, so
> you will not get the rows you expect.
>
> text removed
>
> Joe
What happens if the ORDER BY clause corresponds exactly with the primary key on the table ? From experimentation this seems to work, but it is probably because the rownum is assigned in primary key order and the order by clause then has no effect. Does anyone have any evidence to back this up ?
Tony
sollarst_at_cableol.net
Received on Mon Nov 11 1996 - 00:00:00 CET