Hi

You could try the following. Of course it will only work for the three TransType_IDs

SELECT SUM(CASE WHEN TransType_ID = 0 THEN AMOUNT ELSE null END) SumAmount_TransType_ID_0

, SUM(CASE WHEN TransType_ID = 2 THEN AMOUNT ELSE null END) SumAmount_TransType_ID_2

, SUM(CASE WHEN TransType_ID = 3 THEN AMOUNT ELSE null END) SumAmount_TransType_ID_3

, Transaction_AccNo

FROM Tbl_Transaction

GROUP BY Transaction_AccNo