Thread: yearly quarter report
11-04-10, 14:20 #1Registered User
- Join Date
- Sep 2009
Unanswered: yearly quarter report
we have created table having 4 fields as
1) cash receive daily
2) loan receive daily
3) advances receive daily
4) deposit date
we pass approx 200 entries daily on this format date 01/01/10. now we want to develop a report of first 4 months of the define year.
For example report look like this
Month (1)Cash Receive (2)loan Receive (3)advances Receive Total(1+2+3)
January 10 10 10 30
February 20 05 05 30
March 30 10 10 50
April 40 20 10 70
Please Help me to how can we make a query to fetch this report from the database.
11-04-10, 14:56 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
select to_char(deposit_date,'MONTH'), sum(cash), sum(loan), sum(advances), sum(cash)+sum(loan)+sum(advances)
group by to_char(deposit_date,'MONTH');You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.