I have a table PanelDefn which has list following fields I would like to write a query which recursively gives the data for SubPanel when I query for Panel. It means whenever we encounter FieldType=11 , we need to have recursive query for that. I tried using connect-by. Answer I guess you need below query – This will recursively generate
Tag: connect-by
Oracle SQL/PLSQL: Hierarchical recursive query
I have asked very similar questions before but still haven’t achieved the correct result… third times the charm but I now have a stable parent-child relationship to work with. Every row in the multi-level data set has a cost. For a specific row I need to find the lowest level and roll-up the cost. Then my users will compare the
Given any child in the hierarchy, fetch complete tree by INFORMIX hierarchical SQL
I need a little help with Informix hierarchical sql query. I have table with the following structure : I am able to run the following query successfully : which returns the exact hierarchy as specified in the table above. However, I am trying to achieve something different here. I am trying to get the same result-set given any employee id