Monday, May 10, 2010

Great Recursive SQL SELECT

Check this out

Select HIE_NAME,HIE_CODE,HIE_COST_CENTRE FROM HS_HR_HIERARCHY
 CONNECT BY
PRIOR  HIE_CODE = HIE_RELATIONSHIP START WITH HIE_CODE = '013'

http://www-128.ibm.com/developerworks/db2/library/techarticle/0307steinbach/
0307steinbach.html





Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)