oracle数据库查询问题

Question

如上图的数据，如何变成下图的结构：

根据keyid的值相等来把组合xth的值。

Answer 1

方法1

 select kmh,keyid,WMSYS.WM_CONCAT(TO_CHAR(xth)) as xth FROM table_name  GROUP  BY  kmh,keyid

方法2

 select kmh,keyid,ListAgg(TO_CHAR(xth),',') within GROUP(order by keyid) as xth from table_name GROUP BY kmh,keyid