Re: Help - SQL Syntax
From: james sweeney <Xjames.Xsweeney_at_Xuk.Sun.COM>
Date: 1998/02/06
Message-ID: <34DAFECF.7485EE99_at_Xuk.Sun.COM>#1/1
>
> Does anyone know how to construct an SQL query such that the result set
> is never more than the first ten (10) rows? The result set could be
> less than ten (10), but, never more than ten (10). This must be
> accomplished in one (1) SQL statement.
>
> Please respond to email - dseeley_at_primenet.com
>
> Thank You,
> D. Seeley
Received on Fri Feb 06 1998 - 00:00:00 CET
Date: 1998/02/06
Message-ID: <34DAFECF.7485EE99_at_Xuk.Sun.COM>#1/1
Where rownum < 11
James
>Dwight Seeley wrote:
>
> Does anyone know how to construct an SQL query such that the result set
> is never more than the first ten (10) rows? The result set could be
> less than ten (10), but, never more than ten (10). This must be
> accomplished in one (1) SQL statement.
>
> Please respond to email - dseeley_at_primenet.com
>
> Thank You,
> D. Seeley
Received on Fri Feb 06 1998 - 00:00:00 CET