Showing results for 
Search instead for 
Did you mean: 

how to handle goup sub total for each group in oracle query ?

Former Member
0 Kudos


i want to handle one complex thing in oracle query.

i have a grouping in my oracle query.

i want to do sub total for each group in query and after that i want to subtract one group sub total from previous group subtotal ?

so how can i handle this in oracle query ?

any help is greatly appreciated.


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos


Interesting requirement.

I wonder why are you not using these calculation during the display time. If it is acceptable then you can try using the custom formula with the running total combination in crystral report to achieve to get the required results.

Best regards

Ali Hadi

Former Member
0 Kudos

Hi ,

thanks for given me reply.

but it is mandatory to handle this in query only.

so pls if you have any suggestions that how to handle in query pls let me know.

appreciate your help.

0 Kudos


Since this is something you want to do basically outside of Crystal I suggest you talk to Oracle or your local DBA and ask them how something like this can be done within the SQL Statement. Possibly a Store Procedured could handle this. Oracles Forums would be a better place to get help writing SQL than here.

Thank you


Answers (0)