This makes no sense. Unless you've got an "order by" clause, there is no order
to the rows, so choosing rows 2-4 is no different than choosing rows 1-3 or
18-20.
Perhaps you want "order by personID asc" combined with "select top 4", and then
ignore the 1st row in the result.
-David
On Sunday, July 22, 2001 7:33 AM, Michael Lugassy [SMTP:[EMAIL PROTECTED]]
wrote:
> Alex,
>
> The Database is Access, how can I loop, exactly?
>
> Michael.
>
> > what dastabase? you could do it it in a stored proc with a loop
> >
> > "Michael Lugassy" <[EMAIL PROTECTED]> wrote:
> >
> > Is it possible to SQL-SELECT a specific number of rows from between the
> result
> > set.
> > NOT by using the BETWEEN keyword in the WHERE clause, but by choosing
> > to select only rows x through y.
> >
> > let's say I have this results set
> >
> > personID personNAME
> > 1 Michael
> > 2 Roman
> > 3 David
> > 4 Ilia
> > 5 Uri
> >
> > I want to get Roman till Ilia, WITHOUT specifiying - WHERE personID
> BETWEEN 2
> > AND 4
> > but Specifying something liek:
> >
> > SELECT ROWS 2 TILL 4 FROM personalls (without personID, which I want to
> get!)
> >
> > Is this possible?
> >
> > Michael.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
