0 then 1 else 0 end) unqualitySum, sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') = 0 then 1 else 0 end) qualitySum, M.BILLETTHICK thick, sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') > 0 THEN A.WEIGHT ELSE 0 END) unqualityWeight, SUM(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') = 0 THEN A.WEIGHT ELSE 0 END) qualityWeight, count(*) sumall FROM KCH_DETECTMARTASKLIST A, zyhb_plandetailofplate B, ZYHB_PLANOFMOTHERPLATE M WHERE a.creattime = (select max(creattime) from KCH_DETECTMARTASKLIST where billetid = a.billetid) AND A.BILLETID = B.SLABNO(+) AND B.MOTHERSLAB = M.MOTHERPLATEID(+) AND ？ AND SUBSTR(a.STOVENO, 3, 1) in ('1','2','3') group by M.BILLETTHICK order by M.BILLETTHICK) union SELECT * from (select sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') > 0 then 1 else 0 end) unqualitySum, sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') = 0 then 1 else 0 end) qualitySum, M.BILLETHEIGHT thick, sum(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') > 0 THEN A.WEIGHT ELSE 0 END) unqualityWeight, SUM(case when instr((SELECT NAME_ FROM SCM_BASE_INFO WHERE ID_ = A.DetectStep),'不合格') = 0 THEN A.WEIGHT ELSE 0 END) qualityWeight, count(*) sumall FROM KCZ_DETECTMARTASKLIST A, MB_PLANDETAILOFPLATE B, MB_PLANOFMOTHERPLATE M, kcZ_turnofflist E WHERE a.creattime = (select max(creattime) from KCZ_DETECTMARTASKLIST where billetid = a.billetid and isvalid <> '0') AND A.BILLETID = E.BILLETID(+) AND B.MOTHERPLATEID = M.MOTHERPLATEID(+) AND A.BILLETID = B.PRODUCTNO(+) AND ？ AND SUBSTR(e.STOVENO, 3, 1) in ('1','2','3') group by M.BILLETHEIGHT order by M.BILLETHEIGHT) )T1 group by t1.thick order by t1.thick ]]>