Re: Question and suggestion regarding rownum

From: p! <p!_at_unix.ndo.co.uk>
Date: Fri, 14 Nov 2003 10:16:11 GMT
Message-ID: <3fb4ab62.95972437@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 - 04:16:11 CST