Notice that this will select the first ten rows and order them by amount,
NOT the first ten ordered by amount.
--
Kind reGards,
Gerard
(ghp_at_santens.be; ghp_at_skynet.be)
miguel <jmiguel_at_cet.pt> schreef in artikel
<01bce38e$4aa1a520$0a0a2c0a_at_jmiguel.cet.pt>...
>
>
> Michael G. Schneider <mgs_software_at_compuserve.com> wrote in article
> <01bce36a$2a60d980$0201dede_at_mum>...
> > 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
> >
>
> SELECT * FROM tbl ORDER BY amount WHERE ROWNUM<10
>
>
Received on Tue Oct 28 1997 - 00:00:00 CST
