How to get just x Records

Thread View: borland.public.interbase.sql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by iox Mon, 16 Dec 2002 15:14

#11068

Author: iox
Date: Mon, 16 Dec 2002 15:14

5 lines
1113 bytes

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

Re: How to get just x Records

#11067

Author: 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

Re: How to get just x Records

#11066

Author: 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)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads