Re: Limit Number of Rows Returned

Actually, it is:

.... where ROWNUM < 11;

Paul.

Todd Haddaway <haddaway_at_umbc.edu> wrote in article <355C6CC2.68E1835D_at_umbc.edu>...
> OK,
>
> SQL 101 question - How do I limit the number of rows returned in a
> select. For example, I only want to see the first 10 rows.
>
> I know it's something like:
>
> Select * from table where rows < 11;
>
> Thanks!
>
>
Received on Fri May 15 1998 - 11:52:37 CDT