Re: connect by

In article <8qtht5$evs$1_at_nnrp1.deja.com>,

        redrobin723_at_hotmail.com writes:

> I need to select ONLY the top most parent id from a table which
> includes parent/child ids.
>
> I'm using connect by, but can only seem to retrieve the entire list of
> relationships, not just the top node.

The root node/nodes of a tree constructed in this way is/are typically identified by a null in the parent ID column:

select * from t where parent_id is null;

-- 
Regards,

Richard