Re: Question and suggestion regarding rownum

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Fri, 14 Nov 2003 06:20:21 -0500
Message-ID: <O8SdnVcErsjjJymi4p2dnA@comcast.com>

see my post regarding performance implications (i'm harping, but performance considerations seem to be slipping thru the cracks on this thread) -- mcs
"p!" <p!@unix.ndo.co.uk> wrote in message news:3fb4ab62.95972437_at_news...
| select user_objects.*
| from
| (
| select rownum key, user_objects.*
| from
| (
| select *
| from user_objects
| order by object_id
| ) user_objects
| where rownum <= :max
| ) user_objects
| where key >= :min
Received on Fri Nov 14 2003 - 05:20:21 CST