Re: double linked list

From: DA Morgan <>
Date: Sun, 02 Feb 2003 14:09:21 -0800
Message-ID: <>

Mikito Harakiri wrote:
"--CELKO--" <> wrote in message
> >> Currently I figure to use
>    SELECT cs, cb, level
>      FROM link_t
>     START WITH cb
>               IN (SELECT cb
>                     FROM link_t
>                    WHERE cs = 'A')
>   CONNECT BY PRIOR cb = cs;
> that will return a tree containing all paths with the root as the
> common starting point. <<
> It returns a sequential file that represents a table and that
> represernation  depends on the order of the records (they are no
> longer rows in a table).

Looks like we won't see a "connect-by" chapter in your book;-)

In addition to

I would mention that there is a striking syntactic and semantic similarity
between "connect-by" and "group-by"...

I think Joe's problem is spelled 'SQL SERVER'. CONNECT BY isn't in the Microsoft product.

Daniel Morgan Received on Sun Feb 02 2003 - 23:09:21 CET

Original text of this message