Re: SQL help requested - "linked list"
Date: 21 Aug 2003 15:41:06 -0700
Message-ID: <6dae7e65.0308211441.446e4f19_at_posting.google.com>
Mia <nospam_at_cox.net> wrote in message news:<3F44E6F9.4090306_at_cox.net>...
> Hi Everyone,
>
> I have a query I'm trying to do, and with my limited SQL knowledge I
> don't know how to go about it.
>
> Here's a simplified description of my challenge. I have data in a table
> that forms sets you might describe as singly-linked lists. For example,
> the table contains columns ID and NEXTID, where NEXTID points to the ID
> of some other row. The linked list ends when NEXTID has a zero value.
>
> Given one of the ID values (they're unique), I want to select the IDs
> that occur before and after in that particular linked list. In a
> differnet language I would approach this using a recursive function. Is
> this possible in SQL?
>
> -Mia
1 -2 2 -1 3 0 9 1 14 2
5 record(s) selected with 1 warning messages printed.
HTH
/Lennart
Received on Fri Aug 22 2003 - 00:41:06 CEST