blob: 02ed10baf4d612ab17e7f42fa576f6d2b7014b13 [file] [log] [blame]
select t.gbyt, min(t.oooa.oa.oab.oabc[1].rowValue1) minoooa from `complex.json` t group by t.gbyt having min(t.oooa.oa.oab.oabc[1].rowValue1) in (1, 2, 3, 14, 33, 41, 50) order by minoooa;