Does SAPDB support selecting a tree structure like Oracle?

select LEVEL, EMPNO, ENAME, MGR
from EMP
connect by prior EMPNO = MGR
start with MGR is NULL;

If not, what is the best way to pull out a tree structure?

Thanks,

Dan

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to