如何按字母顺序对查询结果排序?
select b6.S_Architect as S_Architect
from applications a
left outer join
(select id,concat_ws(';' , collect_set(name)) as S_Architect
from solution_architect
group by parentcontentid
) b6 on a.id = b6.Id;
预期结果
Andy;Bravo;Cindy;David
实际结果
Cindy;Bravo;David;Andy
1条答案
按热度按时间nwsw7zdq1#
使用排序数组:
退货: