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

Question

tableIDtext1text11111null1null2222333null2null4443555null3null666变成IDtext1text1111122223334443555666...

Answer 1

qw4432669 2018-09-13只针对上面这种情况-- mysqlSELECT ID,sum(IFNULL(text1, 0)) text1,sum(IFNULL(text2, 0)) text2FROM 表名GROUP BY ID;-- oracleSELECT ID,sum(nvl(text1, 0)) text1,sum(nvl(text2, 0)) text2FROM 表名GROUP BY ID;