.* from zp01 p2 join (SELECT TYPEC,count(TYPEC) as cnt_typec FROM planning_cuisson group by TYPEC HAVINGCOUNT(TYPEC) > 0) p1 where p2.type_cuisson=p1.typec order by cnt_typec asc ;Query query= em.createQuery("SELECT
列Online.TypeA、Online.TypeB和Online.TypeC是重复字段。这是我应该得到的:我得到的是:这是我为获得结果而编写的SQL公式:FROMFLATTEN(FLATTEN(FLATTEN([database.kind_table1],Online.TypeA),Online.TypeB),Online.TypeC)
GROUP BY Id, Online.TypeA, Online.Ty