RE: SQL conect by prior and group by

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