Home > IT Answers > Development > SQL statements question
SQL Server Ask the Experts
2,585 pts.
 SQL statements question
SQL, SQL statements
I have an accounts ENTRY table with many fields like (ac_bal, ac_id , ac_date, ...etc) and I want to retrieve the summation of each account in each month as seen in the table below. 10-01 21-04 02-11-4 ..... jan Feb mar . . . Etc. Can anyone help?

Software/Hardware used:
ASKED: February 24, 2010  7:54 PM
UPDATED: February 18, 2011  8:15 AM
RELATED QUESTIONS
Answer Wiki:
You would have to use a <a href="http://www.w3schools.com/sql/sql_groupby.asp">GROUP BY Statement</a>. -------------------
Last Wiki Answer Submitted:  February 24, 2010  8:54 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The SQL statement below should work:

select ac_id, month(ac_date), sum(ac_bal)
from ENTRY
group by ac_id

Note in the above, I used the MONTH() function, which works in MySQL. Depending on your database, you may need to use a different function to retrieve the month from a date.

Oldcat
 10 pts.