Loading

how to display Hierarchical structure database table

Rakesh Parida

6y655

Hello Friends ,

I am struck in one problem related to database table.

My table STructure is .

Parent ID id name subject

1 1 rakesh math

2 2 kumar sci

1 3 ramesh ssc

2 4 rohit eng

1 5 tom eng

i want output like this order of data like this only

please help me

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nisha Regil6y ago
https://stackoverflow.com/questions/18106947/cte-recursion-to-get-tree-hierarchy

https://www.linkedin.com/pulse/step-by-step-guide-creating-sql-hierarchical-queries-bibhas-mitra/