oracle分组后合并(wm_concat)其中一个字段

oracle分组后合并(wm_concat)其中一个字段
强烈推介IDEA2020.2破解激活,IntelliJ IDEA 注册码,2020.2 IDEA 激活码
  •  使用wm_concat函数
select TLXCONTENT ,wm_concat(RADDRESS) as RADDRESS from t_sendtlx where cdat between '20200101000000' and '20200330235959' and ctyp='DEP' group by TLXCONTENT;

 

本文来源huayang183,由架构君转载发布,观点不代表Java架构师必看的立场,转载请标明来源出处:https://javajgs.com/archives/18749

发表评论