我有一个表:
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
(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
语句中