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

[Kathryn Hogg]

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

-- 
Kathryn
http://womensfooty.com