Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Limiting the resultset returned from a SELECT to the first N rows?

Limiting the resultset returned from a SELECT to the first N rows?

From: Michael G. Schneider <mgs_software_at_compuserve.com>
Date: 1997/10/28
Message-ID: <01bce36a$41773060$0201dede@mum>#1/1 







I would like to write a SELECT statement and limit the number of returned
rows. Something like



   SELECT * FROM tbl ORDER BY amount TOP 10



Is this possible? 



Michael G. Schneider



mgs_software_at_compuserve.com
Received on Tue Oct 28 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US