Source Table:
Tree Represntation of above table:
Expected Output:
Asked
Active
Viewed 332 times
0
-
Could you please provide any code that you have tried? – Rakesh Govindula Jun 13 '22 at 15:46
-
@RakeshGovindula-MT, Thanks for ur time. Just got the code from this link and its working as expected. https://stackoverflow.com/questions/52562607/recursive-cte-in-spark-sql – Aravindhan Jun 13 '22 at 16:28