blob: 87d978b51ee3e2dcad7be12e3a4a880c2990cb23 [file] [log] [blame]
select t.gbyi, t.gbyt, max(t.id) maxid, count(t.oooa.oa.oab.oabc[0].rowId) countid, min(t.oooa.oa.oab.oabc[1].rowValue1) minvalue, max(t.oooa.oa.oab.oabc[1].rowValue2) maxvalue from `complex.json` t group by t.gbyi, t.gbyt order by t.gbyi, t.gbyt;