asked on
AS SQl Query to group partial data
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
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY
ASKER