I can't seem to come up with a solution to the following SQL query, and have
a project dependent on a solution. I'd rather not load the whole database
and then parse it in the code.
With the following Database structure:
Field0 Integer Autonumber
Field1 Integer Unique
Field2 Integer not
On 11/12/02 12:43 PM, Charlie [EMAIL PROTECTED] wrote:
I can't seem to come up with a solution to the following SQL query, and have
a project dependent on a solution. I'd rather not load the whole database
and then parse it in the code.
With the following Database structure:
Field0 Integer
Hi.
On Tue 2002-11-12 at 13:43:09 -0700, [EMAIL PROTECTED] wrote:
I can't seem to come up with a solution to the following SQL query, and have
a project dependent on a solution. I'd rather not load the whole database
and then parse it in the code.
With the following Database structure:
Thanks for the reply, but it isn't quite what is needed.
The problem is that I need all the records between the two occurances of
identical values in field 2, with no records which occur before or after
those two occurances.
For example, the following table with 3 fields:
11 10
2
Hello.
What you wrote does not obviously fit to your previous description.
On Tue 2002-11-12 at 16:25:40 -0700, [EMAIL PROTECTED] wrote:
The problem is that I need all the records between the two occurances of
identical values in field 2, with no records which occur before or after
those
state between rows. hence this has to be accomplished
by multiple SQL queries. one to establish the start and end row indices.
and then another that would take the row indices as constants and
extracts the desired portion of the table. so in fact this might be
appropriately labeled as an 'impossible