Limiting the Returned Recordset.

Article View: bit.listserv.sqlinfo

Article #334

Back to bit.listserv.sqlinfo Previous Next

#334

From: Oron Gill Haus
Date: Thu, 09 Sep 1999 00:00

6 lines
898 bytes

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: <24SB3.6291$Dj2.366764@monger.newsread.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,8a8573ec9d846996,start
X-Google-Attributes: gid11355a,public
From: "Oron Gill Haus" <ohaus@syscom-inc.com>
Subject: Limiting the Returned Recordset.
Date: 1999/09/09
Message-ID: <24SB3.6291$Dj2.366764@monger.newsread.com>
X-Deja-AN: 523028984
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: Abuse Role <abuse@min.net>, We Care <abuse@newsread.com>
X-Trace: monger.newsread.com 936897918 208.222.216.8 (Thu, 09 Sep 1999 13:25:18 EDT)
Organization: MetroNet Internet Services (min.net)
NNTP-Posting-Date: Thu, 09 Sep 1999 13:25:18 EDT
Newsgroups: bit.listserv.sqlinfo