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

It seems as if ROWNUM would be calculated before a sort is done. So a ...

   SELECT * FROM tbl WHERE ROWNUM<10 ORDER BY amount

does not return the 10 rows with the smallest amounts.

Is there some other possibility than ROWNUM?

Michael G. Schneider

mgs_software_at_compuserve.com

> > 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?
> >

> SELECT * FROM tbl ORDER BY amount WHERE ROWNUM<10
Received on Tue Oct 28 1997 - 00:00:00 CST