Select JOB_NAME,STATUS,Count(JOB_NAME) as Fail_Count from COMP_HIS_TBL A where STATUS = 'Failure' Group By JOB_NAME,STATUS
Select JOB_NAME,STATUS,Count(JOB_NAME) as OverallCount from COMP_HIS_TBL Group By JOB_NAME,STATUS
Select A.JOB_NAME,A.STATUS,Count(A.JOB_NAME) as Fail_Count from COMP_HIS_TBL A JOIN (Select JOB_NAME,STATUS,Count(JOB_NAME) as OverallCount from COMP_HIS_TBL Group By JOB_NAME,STATUS) B On A.JOB_NAME=B.JOB_NAME Where A.STATUS = 'Failure' Group By A.JOB_NAME,A.STATUS
JOIN
SELECT JOB_NAME, SUM(CASE Status WHEN 'Failure' THEN 1 ELSE 0 END) As Fail_Count, COUNT(JOB_NAME) As OverallCount FROM COMP_HIS_TBL GROUP BY JOB_NAME ;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)