Tag: CTE

  • Advance SQL: Finding Hierarchical data using Recursive CTE

    Often we have a Table that store Hierarchical data, such as any shopping cart will have product category in table that store parent table within same table. We often use such information. The typical structure of table is ID, Name , ParentID Where ParentID is ID within same table or for Top level it is…