Re: How can I limit the NUMBER of rows returned?
From: James Richard <no email>
Date: Fri, 10 Feb 1995 12:30:39 GMT
Message-ID: <1995Feb10.123039.17391_at_newton.ccs.tuns.ca>
Date: Fri, 10 Feb 1995 12:30:39 GMT
Message-ID: <1995Feb10.123039.17391_at_newton.ccs.tuns.ca>
In article <3ghgbr$g3l_at_news-s01.ca.us.ibm.net> ebsmith_at_ibm.net writes:
>Doing selects from Solaris middleware with ProC to an Oracle7 server.
>Returned tables are normally small & quick, but occasionally we get a query
>which returns way too many rows so that even the first fetch is greatly delayed.
>I'd be happy to take the first 100 rows quickly, and ignore the rest.
>Any suggestions?
> --Baird Smith
WHERE
ROWNUM <= 100;
Ordering does NOT effect ROWNUM
(which is a bummer in itself!!)
James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!"
Received on Fri Feb 10 1995 - 13:30:39 CET