"DB2" GB industry classified storage, through SQL query out hierarchical relationship

New Table

DROP TABLE Industry; CREATE TABLE Industry (industrycode varchar (+), industryname varchar, parentid varchar (40))

Click to download INSERT statement

Data:

Now that the data is this way, we need to find the corresponding hierarchical relationship, for example:

Implement SQL as follows:

SELECTA. IndustryCode as Class01,a.industryname Class_01nm,b.industrycode as Class02,b.industryname CLASS_02NM,C.IndustryCode As Class03,c.industryname Class_03nm,c.industrycode as Class04,c.industryname Class_04nm,dense_rank () over (ORDER by A. IndustryCode) seqfrom industry a,industry b,industry c,industry dwhere A.industrycode=b.parentid and B.INDUSTRYCODE=C. ParentID and C.industrycode=d.parentid

"DB2" GB industry classified storage, through SQL query out hierarchical relationship