mysql中的UNION面试题
#UNION面试题
#将a表和b表合并,并且让a表中和b表中id相同的行的num相加
#以下是我想到的2种方式
#方式1
SELECT a.id, a.num + b.num FROM a,b WHERE a.id = b.id
UNION ALL
SELECT b.id, b.num FROM b WHERE b.id NOT IN(SELECT a.id FROM a WHERE a.id = b.id);
#方式2
SELECT temp.id, SUM(temp.num) FROM
(SELECT * FROM a UNION ALL SELECT * FROM b) AS temp GROUP BY temp.id;