sql如何合并行，具体如下：

Question

tableIDtext1text11111null1null2222333null2null4443555null3null666变成IDtext1text1111122223334443555666...

Answer 1

qw4432669 
2018-09-13

只针对上面这种情况
-- mysql
SELECT ID,sum(IFNULL(text1, 0)) text1,sum(IFNULL(text2, 0)) text2
FROM 表名
GROUP BY ID;
-- oracle
SELECT ID,sum(nvl(text1, 0)) text1,sum(nvl(text2, 0)) text2
FROM 表名
GROUP BY ID;