I Have a MS sql table which has 3 columns Account,Month, Fee. There are four accounts (A1,A2,A3,A4)and each account has associated fee for each month. No I want to query the table in such a way I can see all the Account fees for all the months , however for account A4 i want show sum value of A1 and A2 grouped by each month , So basically I want to show A4 = A1+A2 for every month Along with other account values
Something like this
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.