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

[Carol Williams]

You could do something like:

select * from mytable limit 120;

to limit the response to the first 120 rolls.

Carol Williams

On Nov 9, 2007 11:10 AM, Tricia Bowen <tricia.bowen at gmail.com> 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?
>
> Googling for answers brings back everything under the sun.
> --Tricia
> _______________________________________________
> Techtalk mailing list
> Techtalk at linuxchix.org
> http://mailman.linuxchix.org/mailman/listinfo/techtalk
>



-- 
If you can spend a perfectly useless afternoon in a perfectly useless
manner, you have learned how to live.  -- Lin Yutang