oracle与mysql多行合并 博客分类： databasestudy oraclemysql多行合并行转列

1.oracle多行合并一行
效果：

SELECT a, WMSYS.WM_CONCAT(b) AS name FROM aa  GROUP BY a;

2.mysql多行合并一行

SELECT type, GROUP_CONCAT(name SEPARATOR ',') AS name FROM tt WHERE type=1 GROUP BY type;

技术交流群：312740759