[Techtalk] How do I limit my oracle resultset to 100 rows

Kathryn Hogg kjh at flyballdogs.com
Fri Nov 9 18:06:47 UTC 2007

Tricia Bowen wrote:
> Help!
> I have a query that returns over 10,000 rows. It's a pretty sizable query
> so
> it takes a while to run. How do I limit the number of rows returned to
> 100?

if its oracle 8i or newer, use the SQL standard by adding "row_number <=
100" to your where clause.

if its an older version of oracle, replace row_number with rownum


More information about the Techtalk mailing list