On 12/5/06 3:22 PM, John Siracusa wrote:
> On 12/5/06 3:11 PM, Kevin McGrath wrote:
>>> select * from (<original query>) where rownum >= X and rownum <= Y
>>
>> Nope. You cannot do a rownum > or >= that way. A BETWEEN will aslo not
>> work. You an only do a:
>>
>> select * from (<original query>) where rownum <= Y
>>
>> Using that method.
>
> What version of Oracle are you using? On 10g here, the form I proposed
> works.
Oops, I take that back. It appears to work with:
... rownum >= 1 and rownum <= 2
but fails for most other values. Blah.
-John
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
