By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 2 Duplicates: 0 Warnings: 0
| id | cat | parent_id | is_active |
|---|---|---|---|
| 1 | animals | null | 1 |
| 2 | domestic | 1 | 1 |
| 3 | cat | 2 | 1 |
| 4 | dog | 2 | 1 |
Records: 2 Duplicates: 0 Warnings: 0
| id | cat | parent_id | is_active |
|---|---|---|---|
| 1 | animals | null | 1 |
| 2 | domestic | 1 | 1 |
| 3 | cat | 2 | 1 |
| 4 | dog | 2 | 1 |