Home » SQL & PL/SQL » SQL & PL/SQL » Grouping DATA
Grouping DATA [message #262093] Fri, 24 August 2007 08:28 Go to next message
itzikma
Messages: 6
Registered: August 2007
Junior Member
Hi All,

Another help please.

I creadeted culculation fields and here is the result:

Account No Account des Jan-07 Feb-07 Mar-07 Q1-07
410011 Product Sa .00 .00 .00 .00
410011 Product Sa .00 -508.87 .00 -508.87
410011 Product Sa -554.17 .00 .00 -554.17
410011 Product Sa .00 .00 .00 .00
410011 Product Sa .00 .00 -2,547.55 -2,547.55
410031 Post Co .00 .00 .00 .00
410031 Post Co .00 .00 -14.97 -14.97
410031 Post Co .00 .00 .00 .00
410031 Post Co -17.14 .00 .00 -17.14
410031 Post Co .00 -5.64 .00 -5.64

What should I do to view it:
Account No Account Jan-07 Feb-07 Mar-07 Q1-07
410011 Product Sa -554.17 -508.87 -2,547.55 -3,610.58
410031 Post Co -17.14 -5.64 -14.97 -37.74

Attached a file(itzikma.xls)

Need Your help

10x

Itzik
  • Attachment: itzikma.xls
    (Size: 17.50KB, Downloaded 138 times)

[Updated on: Fri, 24 August 2007 08:31] by Moderator

Report message to a moderator

Re: Grouping DATA [message #262095 is a reply to message #262093] Fri, 24 August 2007 08:32 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First,
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

Then,
Just use sum and group by account% columns

Regards
Michel
Previous Topic: if in where or conditional where
Next Topic: Oracle function within a subquery
Goto Forum:
  


Current Time: Mon Dec 05 08:50:44 CST 2016

Total time taken to generate the page: 0.07520 seconds