Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme 

recursive cte

Language: Editor: Layout:
View schema
Execution time: 0,02 sec, rows selected: 9, rows affected: 3, absolute service time: 0,17 sec 
edit mode |  history
   Id Parent Description NumberOfThings Number
1 A NULL This is A 1 NULL
2 B NULL This is B 3 NULL
3 C NULL This is C 2 NULL
4 A-1 A This is A 1 1
5 B-1 B This is B 1 1
6 C-1 C This is C 1 1
7 B-2 B This is B 1 2
8 C-2 C This is C 1 2
9 B-3 B This is B 1 3