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_at_news.demon.co.uk>
Date: Tue, 19 Jun 2001 14:44:51 +0100
Message-ID: <992958219.7261.0.nnrp-14.c30bdde2_at_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 - 15:44:51 CEST