[Techtalk] How do I limit my oracle resultset to 100 rows
carolswilliams at gmail.com
Fri Nov 9 17:33:41 UTC 2007
You could do something like:
select * from mytable limit 120;
to limit the response to the first 120 rolls.
On Nov 9, 2007 11:10 AM, Tricia Bowen <tricia.bowen at gmail.com> wrote:
> I have a query that returns over 10,000 rows. It's a pretty sizable query
> it takes a while to run. How do I limit the number of rows returned to
> Googling for answers brings back everything under the sun.
> Techtalk mailing list
> Techtalk at linuxchix.org
If you can spend a perfectly useless afternoon in a perfectly useless
manner, you have learned how to live. -- Lin Yutang
More information about the Techtalk