如何在mysql中对同一个表和sum (值)进行联合查询？

Question

我有一张桌子

OC  Period(MM/YYYY) Ing
CHO 04/01/2016      100
CHO 04/01/2016      200
CHO 04/01/2016      0
CFE 04/01/2016      400
CFE 04/01/2016      350
CFE 04/01/2016      0

我有一个这样的SQL查询：

  (SELECT OC,Ing FROM contacts c where ing > 0)
  UNION ALL
  (SELECT OC,Sum(Ing) FROM contacts c where ing = 0 Group by OC)

我想得到这样的结果：

Ref Period(MM/YYYY) Ing
CHO 04/01/2016      100
CHO 04/01/2016      200
CHO 04/01/2016      300
CFE 04/01/2016      400
CFE 04/01/2016      350
CFE 04/01/2016      750

Answer 1

(SELECT c.OC, c.Period, c.Ing FROM contacts c where c.ing > 0)
UNION ALL
(SELECT c.OC, c.Period, Sum(c.Ing) AS Ing FROM contacts c Group by c.OC, c.Period)

如果需要对输出进行排序，可以将其封装在另一个select from语句中