Re: How can I limit the NUMBER of rows returned?

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

Try using the pseudocolumn ROWNUM in your where clause

e.g. WHERE .......

       AND ROWNUM < 101

-- 
----------------------------------------------------------------------
Brian Morley       morleb_at_cbr.hhcs.gov.au
Dept Human Service & Health, Brisbane, Australia