| 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 where t.oooa.oa.oab.oabc[1].rowValue2 > 1000 and t.oooa.oa.oab.oabc[1].rowValue2 < 20000 group by t.gbyi, t.gbyt order by t.gbyi, t.gbyt; |