Re: sql statement

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Tue, 19 Jun 2001 14:44:51 +0100
Message-ID: <992958219.7261.0.nnrp-14.c30bdde2@news.demon.co.uk>

FAQ: "select ... where rownum < 51"

"<" operator is the only one you can use with rownum clause. If you want more info, search for it.

"Nicholas Mudie" <nmudie_at_chello.com> wrote in message news:SAIX6.100068$2f1.6172303_at_amsnews02.chello.com...
> Hello,
>
> I want to return the first 50 rows of my sql statement results. How do I
do
> this???
>
> I have hundreds of rows that are resturned in my CGI script but I only
want
> 50 per page.
>
> Cheers,
> Nicholas Mudie
> CHELLO BROADBAND
>
>
Received on Tue Jun 19 2001 - 08:44:51 CDT