Re: How can I limit the NUMBER of rows returned?
From: stowe <stowe_at_aol.com>
Date: 30 Jan 1995 17:58:54 GMT
Message-ID: <3gj9d0$2ue_at_News1.mcs.com>
Date: 30 Jan 1995 17:58:54 GMT
Message-ID: <3gj9d0$2ue_at_News1.mcs.com>
> 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?
select * from ...
where ROWNUM < 100;
Received on Mon Jan 30 1995 - 18:58:54 CET