By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
| ROW_NUM | PARENTID | PARENTNAME | ROW_NUM | CHILDID | CHILDNAME |
|---|---|---|---|---|---|
| 1 | H1 | Header 1 | 1 | D1 | Detail D1 |
| 1 | H1 | Header 1 | 2 | D2 | Detail D2 |
| 2 | H2 | Header 2 | 1 | D3 | Detail D3 |