Re: Cap rows returned

From: Lionel Mandrake <nobody_at_nospam.nowhere.nohow>
Date: Thu, 12 Jul 2001 03:00:40 GMT
Message-ID: <sp837.127405$mG4.63394118@news1.mntp1.il.home.com>

What version are you using?

Check these out...
http://asktom.oracle.com/pls/ask/f?p=4950:8:182341::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:476421442771
http://asktom.oracle.com/pls/ask/f?p=4950:8:182341::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:750625651018
http://asktom.oracle.com/pls/ask/f?p=4950:8:182341::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:653824151081 Tom is hands down one of the best.

HTH "Gabriel Millerd" <millerd_at_ns1.rli-net.net> wrote in message news:9iigcj$i9g$1_at_news.powerisp.com...
>
> how do i just grab the top 10 rows of this query? a few million records
returned to just grab the first few is slow and wasteful across the board.
>
> select
> sic_opt_ains.code
> from
> plink.sic_opt_ains,
> plink.sic2sic
> where
> sic2sic.child=sic_opt_ains.code
> order by
> sic_opt_ains.ains desc
Received on Wed Jul 11 2001 - 22:00:40 CDT