SORTING WITHIN HIERARCHY REPORTS
From: <magc_at_vms.cis.pitt.edu>
Date: 1995/05/05
Message-ID: <3oe1c8$60q_at_usenet.srv.cis.pitt.edu>#1/1
.
.
.
Date: 1995/05/05
Message-ID: <3oe1c8$60q_at_usenet.srv.cis.pitt.edu>#1/1
Does anyone know how to sort the descendants within a hierarchy report created with the CONNECT BY clause? For example (from page 4-364 of SQL Language Reference Manual):
SELECT ename, empno, mgr, job
FROM emp
START WITH job = 'PRESIDENT'
CONNECT BY PRIOR ename = mgr
returns the following:
KING 7839 PRESIDENT
JONES 7566 7839 MANAGER
SCOTT 7788 7566 ANALYST
ADAMS 7876 7788 CLERK
FORD 7902 7566 ANALYST
SMITH 7369 7902 CLERK
BLAKE 7698 7839 MANAGER
ALLEN 7499 7698 SALESMAN
.
.
.
I would like to sort the descendants and return the following:
KING 7839 PRESIDENT
BLAKE 7698 7839 MANAGER
ALLEN 7499 7698 SALESMAN
JONES 7566 7839 MANAGER
FORD 7902 7566 ANALYST
SMITH 7369 7902 CLERK
SCOTT 7788 7566 ANALYST
ADAMS 7876 7788 CLERK
Any help will be appreciated. Received on Fri May 05 1995 - 00:00:00 CEST
