1回答

• 

  慕田峪9362115

  2019-06-04 12:09:25

   单纯 group by 不能在分组里排序吧 需要listagg(..,..) within group(order by..)来调整顺序吧

  select ci,listagg(sname,',') within group(order by sid) from

   aa,bb  where instr(aa.stus,sid)>0 

  group by ci 

  
  

  0 0