SELECT C.SUBSET_ID , NVL(SUM(C.RECORD_UNAVAILABLE), 0) FROM IEC_G_MKTG_ITEM_CC_TZS C WHERE C.SUBSET_ID IS NOT NULL GROUP BY C.CAMPAIGN_SCHEDULE_ID , C.LIST_HEADER_ID , C.SUBSET_ID
View Text - HTML Formatted
SELECT C.SUBSET_ID , NVL(SUM(C.RECORD_UNAVAILABLE) , 0) FROM IEC_G_MKTG_ITEM_CC_TZS C WHERE C.SUBSET_ID IS NOT NULL GROUP BY C.CAMPAIGN_SCHEDULE_ID , C.LIST_HEADER_ID , C.SUBSET_ID