SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table g (gameID int, gameInfo json); insert into g values (1, '{"scores": [ {"scoreType": "skill", "score": 1 }, {"scoreType": "speed", "score": 3 }, {"scoreType": "strength", "score": 2} ]}'), (2, '{"scores": [ {"scoreType": "skill", "score": 4 }, {"scoreType": "speed", "score": 4 }, {"scoreType": "strength", "score": 4 } ]}'), (3, '{"scores": [ {"scoreType": "skill", "score": 1 }, {"scoreType": "speed", "score": 3 }, {"scoreType": "strength", "score": 5 } ]}'); select gameID, (s->>'score')::int from g, lateral json_array_elements((gameInfo->>'scores')::json) s -- group by gameID ;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear