Re: How to get just x Records

Article View: borland.public.interbase.sql

Article #11066

Back to borland.public.interbase.sql Previous Next

#11066

From: Jeff Overcash (TeamB)
Date: Thu, 19 Dec 2002 20:21

19 lines
1774 bytes

IB 6.0 you would have to write a SP that returns the rows until you hit the
passed amount you want.  IB 6.5 and up you can use the new ROWS keyword.

iox wrote:
> 
> In oracle i used to do this a lot,
> 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

-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
Maybe it was infatuation or the thrill of the chase.
Maybe you were always beyond my reach and my heart was playing safe.
But was that love in your eye I saw or the reflection of mine?
Give me time, won't you give me that time!
Welcome back to the circus.            (Fish)

Technical Details

Message-ID: <3E022A46.91B15290@mindspring.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-7-bit
X-Google-Thread: 114a0e,b27f0e7287c0c90f,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-19 12:32:06 PST
Message-ID: <3E022A46.91B15290@mindspring.com>
Date: Thu, 19 Dec 2002 15:21:26 -0500
From: "Jeff Overcash (TeamB)" <jeffovercash@mindspring.com>
Organization: TeamB
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: How to get just x Records
References: <3e02294b@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 66.32.64.236
X-Trace: newsgroups.borland.com 1040329108 66.32.64.236 (19 Dec 2002 12:18:28 -0800)
Lines: 19
X-Authenticated-User: overcash
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