Hi, I want SUM of count of the number of records available in database for first WHEN in below query. For example if i have 2 records in database for first case(prd_cd='1') , 5 for second case(prd_cd='2') and 10 for third case(pr_cd='3') then I should get 17 as sum of count in diplay. Can someone help?
WHEN prd_cd='1' or prd_cd='2' or pr_cd='3' THEN 'PROCESSED' <---- I am looking for this only
WHEN prd_cd='X' THEN ' NOT PROCESSED'
ELSE 'UNKNOWN' END AS "Key Check Points", count(*) as "Rules"
from Table 1 where date(crt_ts) = current date
group by prd_cd with ur ;