framework/resources/Functional/complex/json/complex111.q

select t.id, t.oooa.oa.oab.oabc, t.oooa.oa.oab.oabc[1].rowValue2 from `complex.json` t order by t.oooa.oa.oab.oabc[1].rowValue2 limit 50;