SELECT COUNT (STATUS_FLAG) as count, CASE WHEN STATUS_FLAG ='Y' then 'success' when status_flag ='I' then 'PROCESSED' WHEN STATUS_FLAG = 'N' then 'PENDING' END AS STATUS FROM TABLENAME group by status_flag;
SUCCESS PROCESSED PENDING VALUE VALUE VALUE.
SELECT SUM(DECODE(STATUS_FLAG,'Y',1,0)) AS Success, SUM(DECODE(STATUS_FLAG,'I',1,0)) AS Processed, SUM(DECODE(STATUS_FLAG,'N',1,0)) AS Pending FROM TableName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)