How to write Recursive With Query for my requirment
Case 1 This part# is under another component. first level
Case 2: This part# is under another component's component . 2nd level. Sometimes it may exist in nth level.
How to write the REcursive with clause.?
Select part#, I can get other component here. level1 but if part# exists in nth component how to get it
from
table
Appreciate if you can guide with any suggestion or pseduo logic
Thanks