Re: Need help on query which show total sum of result incorrect
Posted by:
zell dsf
Date: November 29, 2017 12:16AM
This is the sample query, i am working on.
http://sqlfiddle.com/#!9/e6922f/6
I am trying to sum the quantity of product being ordered. It gives me wrong output which caused by the same cart id is used in different orders. I just want to get the query to work to show correct output.
The expected result should be
1, 1, 1 for each product id.
Subject
Written By
Posted
November 28, 2017 08:09PM
November 28, 2017 11:01PM
Re: Need help on query which show total sum of result incorrect
November 29, 2017 12:16AM
November 29, 2017 10:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.