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

ebsmith_at_ibm.net wrote:
: 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 
      SELECT xxx,yyy,zzz FROM A WHERE ROWNUM < 101;

This should work with your problem.

      +------------+
     /| +--------+ |
    //| |      //| | Joseph P. Bennett
   //|| |_____///| | Systems Consultant
  //_|| |_____// | | bennettj_at_ugly.microserve.net
  ||_|| |____ ||_| |
  || ||     | ||   |
  || /+-----| ||---+ "There are a lot of dumb people with powerful tools."
  ||// _____| ||/ /  Jonah Seiger, 1994
  | / /_______|  /
  |/__________| /