RE: SQL conect by prior and group by
From: Asgcorp <asgcorp_at_aol.com>
Date: 1996/02/11
Message-ID: <4flgn3$ao2_at_newsbf02.news.aol.com>#1/1
Date: 1996/02/11
Message-ID: <4flgn3$ao2_at_newsbf02.news.aol.com>#1/1
Hi Ben,
Try this, it worked for me:
select id, name, level
from MYTABLE
where parent is NOT NULL
connect by id = prior parent
order by level, name;
This assumes that the top of structure is denoted by a NULL parent id.
Ron Evans
ASGCORP_at_AOL.COM
Received on Sun Feb 11 1996 - 00:00:00 CET