##--mysql中的多行查询结果合并成一个,去重复,排序,指定分隔符--
SELECT mcht_no,sum(available_amt) as tot_available_amt,group_concat(distinct seller_id order by seller_id desc separator ';') as s_seller_id
FROM `lgf-transcore-db`.t_mcht_shop_inf
group by mcht_no order by tot_available_amt desc;
mysql中的多行查询结果合并成一个
于 2022-03-10 11:29:52 首次发布