By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
5 rows affected
1 rows affected
| studenttypes |
|---|
| {"studentTypes" : [{"id" : 1, "name" : "Hostel", "students" : [{"id" : 1, "name" : "First", "studentTypeId" : 1}]}, {"id" : 2, "name" : "Home", "students" : [{"id" : 4, "name" : "Fourth", "studentTypeId" : 2}, {"id" : 5, "name" : "Fifth", "studentTypeId" : 2}]}, {"name" : "Unassigned", "students" : [{"id" : 3, "name" : "Third", "studentTypeId" : null}, {"id" : 2, "name" : "Second", "studentTypeId" : 1}]}]} |