因group by分组后 不满足条件的查不出那一行数据 请大佬指点 SELECT sum(BADQTY) ,MACHINECODE FROM DGBINREWORK WHERE MACHINECODE in ('B68','B65','B66','B74','B67','B57') AND REASONCODE='油污' AND TO_CHAR(EVENTTIME,'YYYY-MM-DD')>= ('2021-10-13') AND TO_CHAR(EVENTTIME,'YYYY-MM-DD')<= ('2021-10-13') group by MACHINECODE ORDER BY MACHINECODE |