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


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

Original text of this message