By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
| name | country | city |
|---|---|---|
| alok | india | delhi |
| ram | india | kolkata |
| shyam | india | kanpur |
| krishna | us | newyork |
| ajit | india | delhi |
| sami | india | delhi |
| mohamad | india | kolkata |
| country | json_object_agg |
|---|---|
| india | { "kanpur" : ["shyam"], "delhi" : ["alok", "ajit", "sami"], "kolkata" : ["ram", "mohamad"] } |
| us | { "newyork" : ["krishna"] } |