Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to have Subtotal on Months in Query

kamranpathanJul 7 2010 — edited Jul 8 2010
Dear Users I've data like this:

Date Val
01-Jun-10 10
02-Jun-10 15
03-Jun-10 05
01-Jul-10 10
02-Jul-10 15

Now how can I've sub-total on each monthe.g June & July in above example and a grand total at the end???

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 5 2010
Added on Jul 7 2010
11 comments
9,470 views