How do I get Parent with multiple children in desc order in sql server to show the newly created parent with its children at top in a List : [enter image description here][1]


  [1]: https://i.stack.imgur.com/SSmyN.png## 


----------
I need to get in desc order as Parent1 with its children, parent2 with its children and so on..

 ##