SELECT worksheet_header_id, bank_account_id, sum(balance) FROM CE_CP_DISC_TRX_V WHERE TRX_TYPE <> 'IDA' GROUP BY worksheet_header_id, bank_account_id
View Text - HTML Formatted
SELECT WORKSHEET_HEADER_ID , BANK_ACCOUNT_ID , SUM(BALANCE) FROM CE_CP_DISC_TRX_V WHERE TRX_TYPE <> 'IDA' GROUP BY WORKSHEET_HEADER_ID , BANK_ACCOUNT_ID