Re: How to get just x Records

Article View: borland.public.interbase.sql

Article #11067

Back to borland.public.interbase.sql Previous Next

#11067

From: Craig Stuntz TeamB
Date: Thu, 19 Dec 2002 20:18

15 lines
1482 bytes

In article <3e02294b@newsgroups.borland.com>, iox@hotmail.com says...
> Select * from table where rownum =< 50
> 
> This will bring me just 50 records from the tables it's there any way to do
> this in IB6, D6
> 
	In IB 6.5 and higher, use the ROWS keyword.

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Technical Details

Message-ID: <MPG.186bf3a23031bad298a460@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!ash.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3e02294b@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,b27f0e7287c0c90f
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-19 12:32:06 PST
From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com  (but use vertexsoftware to email)>
Newsgroups: borland.public.interbase.sql
Subject: Re: How to get just x Records
Date: Thu, 19 Dec 2002 15:18:32 -0500
Message-ID: <MPG.186bf3a23031bad298a460@newsgroups.borland.com>
References: <3e02294b@newsgroups.borland.com>
Organization: Vertex Systems Corporation
X-Newsreader: MicroPlanet Gravity v2.60
NNTP-Posting-Host: 65.86.87.242
X-Trace: newsgroups.borland.com 1040329117 65.86.87.242 (19 Dec 2002 12:18:37 -0800)
Lines: 15
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!ash.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message