CONNECT BY sql statement

From: Carol L. Stimmel <cstimme_at_advtech.uswest.com>
Date: 1997/06/27
Message-ID: <33B3DDB5.332E@advtech.uswest.com>#1/1

in using a connect, as in:

SELECT ID from table
START WITH ID='1234'
CONNECT BY ID = PRIOR PARENT_ID I get a list of ids back. In my case, I just want to report back the first parent id encountered. Any clues on how I can do this. I thinking I'm missing something obvious.

Thanks,
Carol

---

Carol Stimmel Received on Fri Jun 27 1997 - 00:00:00 CDT