blob: 7704442b76aeaba1ad233a8013f21e7857a29c41 [file] [log] [blame]
select tt.gbyi, max(tt.oooioa.oab.oabc) from ( select t.gbyi gbyi, t.oooi.oa oooioa from `complex.json` t) tt group by tt.gbyi order by tt.gbyi;