Re: Limiting the Returned Recordset.

Article View: bit.listserv.sqlinfo

Article #336

Back to bit.listserv.sqlinfo Previous Next

#336

From: David Bechtel
Date: Sun, 12 Sep 1999 00:00

19 lines
1333 bytes

I'm new to SQL, but I saw a note in an SQL Tips newsletter that I receive
regarding this.
The answer is the ROWNUM clause.  I don't have the reference here, but I
think the
syntax was "Select * from something where rownum <20;"  I believe from the
sample
that I tried that it doesn't fetch all rows unless there are other clauses
that require it.

Dave Bechtel

Oron Gill Haus wrote:

> Is there an SQL command/keyword that allows the results of a query to be
> limited to a specified number of rows?  If it does exist, does the
> interpreter fetch ALL rows prior to returning??
>
> Oron Gill Haus
> oron@syscom-inc.com

Technical Details

Message-ID: <37dc366a$0$11104@news.voyager.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <24SB3.6291$Dj2.366764@monger.newsread.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,8a8573ec9d846996
X-Google-Attributes: gid11355a,public
From: David Bechtel <dbechtel@voyager.net>
Subject: Re: Limiting the Returned Recordset.
Date: 1999/09/12
Message-ID: <37dc366a$0$11104@news.voyager.net>
X-Deja-AN: 524245778
Content-Transfer-Encoding: 7bit
References: <24SB3.6291$Dj2.366764@monger.newsread.com>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@voyager.net
X-Trace: K5Si:bCC31]I5[332>a9Y[9hSN`^GeEc\4P9cX5n4aQWjbAX4KX[\aYOI\^Vn\Z\N[iKJ2FKj>JBRDV5G\blM=d_
Organization: Voyager.Net - East Lansing, MI
MIME-Version: 1.0
Newsgroups: bit.listserv.sqlinfo

Reply to Parent Message