And Oracle's standard is

SELECT ... WHERE ROWNUM < NumberOfRows

-----Original Message-----
From: Charlie Caro [mailto:ccaro@...]
Sent: Wednesday, May 31, 2000 8:16 AM
To: IB-Architect@egroups.com
Subject: Re: [IB-Architect] Records returned




Louis van Alphen wrote:

>
> To touch upon an age-old subject:
>
> Can a feature be added to enable one to specify the maximum number of rows
> to be returned by a query. I know that this can be done with a SP, but
> using a SP for prohibits the use of a dynamic SQL query from a client

where

> the client will specify the columns, WHERE clause, etc.
>

To review: Yes. It's possible to add such a feature especially since the
engine
already supports that notion.

> I don't know if this is patr of the SQL standard though...

No, it's not part of the standard although several vendors seem to have
settled
on a syntax of 'SELECT TOP <n> ...'.

>
> Thanks
>
> ------------------------------------------------------------------------
> Hot off the press- summer's here!
> School's out and it's sizzling hot. Whether you're planning a
> graduation party, a summer brunch, or simple birthday party,
> shop GreatEntertaining.com before your next celebration.
> http://click.egroups.com/1/4473/4/_/830676/_/959785649/

<http://click.egroups.com/1/4473/4/_/830676/_/959785649/>

> ------------------------------------------------------------------------
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com

_____

<http://click.egroups.com/1/3373/4/_/830676/_/959786352/>
<http://adimg.egroups.com/img/3373/4/_/830676/_/959786352/>

_____

To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com






[Non-text portions of this message have been removed]