mysql中的多行查询结果合并成一个

##--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;