MySQL Forums
Forum List  »  Newbie

Re: Calculate sum of distinct Rows
Posted by: Bob Field
Date: March 23, 2006 05:24PM

The duplicate entries for a particular SSN are going to have to be eliminated by some means or SUM is going to continue to sum all of them. Why do the duplicates exist? What if duplicate SSNs had different request amounts? Are these multiple requests for the same amount? Many questions. The issues go deeper than simply trying to ignore the duplicates to why the duplicates are there in the first place.

Options: ReplyQuote

Written By
Re: Calculate sum of distinct Rows
March 23, 2006 05:24PM

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.