SQL计数不存在的项目

试试这个

SELECt A.status, COUNT(DISTINCT G.ID) statusCntFROM (SELECt 'OK' status FROM DUAL      UNIOn       SELECt 'NOK' status FROM DUAL      UNIOn       SELECt 'PENDING' status FROM DUAL      UNIOn       SELECt 'REJECTED' status FROM DUAL     ) AS A LEFT JOIN groups G ON A.status = G.STATUS GROUP BY A.status;