想请教一个sql的问题，大神帮帮忙！

Question

正如上图，我想根据发票号去重，然后对应的订单编号不合并，这个sql怎么写呢？

Answer 1

如果是ORACLE的话，可以用listagg函数
SELECT T.ORDER_NUMBER, listagg(T.ORDER_NUM,',') within group (order by T.ORDER_NUM) AS ORDER_NUM FROM TABLENAME T

GROUP BY T.ORDER_NUMBER;

SQL语句里TABLENAME换成你的表名应该就可以。