select BATCH_CASH_NO, GROUP_CONCAT(distinct TRADE_NO) AS CONTENT
from T_PAY_PINGAN_CASH
where BATCH_CASH_NO != ''
group by BATCH_CASH_NO ;
select BATCH_CASH_NO, GROUP_CONCAT(distinct TRADE_NO) AS CONTENT
from T_PAY_PINGAN_CASH
where BATCH_CASH_NO != ''
group by BATCH_CASH_NO ;
转载于:https://my.oschina.net/chaun/blog/385416