select * from subq 
where rowid in (select rowid from subq 
                where rownum <= 100 
                    MINUS
                select rowid from subq
                where rownum <= 90)
</pre>

<i>[1] The Oracle dependencies in this query are rowid and rownum.  Other databases have other means of limiting query results by row position.
</i>

		<br><br>

-- <A HREF="/shared/community-member?user_id=236162">Kevin Murphy</a>, February 10, 2003</blockquote>
<blockquote>
		And in PostgreSQL (and MySQL too for that matter) it is as simple as:

<p>

select * from my_table order by my_id limit 90,10

<p>

An easier way for Oracle (according to a random post in a devshed.com forum I googled) would be like this:

<p>

select * from my_table order by my_id where rownum between 90,100

<p>

(Though the whole point about how to use MINUS is well taken)

		<br><br>

-- <A HREF="/shared/community-member?user_id=237502">Gabriel Ricard</a>, February 26, 2003</blockquote>
<blockquote>
		Oops. I was wrong. Phil emailed me and explained that my rownum example won&#39;t work (just goes to show that not everything you find on the internet is right!).

		<br><br>

-- <A HREF="/shared/community-member?user_id=237502">Gabriel Ricard</a>, March 17, 2003</blockquote>

	<center><a href="/comments/add?page_id=3461">Add a comment</a></center>

<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-315149-1";
urchinTracker();
</script></body></HTML>