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

Michael G. Schneider wrote:
>
> 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

Hi Michael!

Try the following:
  SELECT * FROM tbl WHERE rownum < 10 ORDER BY amount;

HTH.
  Harry

-- 
                                                      ///
  Hiroshima '45   Chernobyl '86   Windows '95        (O O)
-------------------------------------------------oOO--(_)--OOo---------
  "There is more than one way to do it!"

(Remove -NOSPAM- from my email address)