MySQL Forums
Forum List  »  Newbie

Re: Calculate sum of distinct Rows
Posted by: Shantanu Oak
Date: March 24, 2006 10:14AM

select DECISION, COUNT(*), sum(REQUESTED_AMT) FROM
(SELECT DISTINCT DECISION, b_SSN, REQUESTED_AMT, APP_DT FROM result) AS MYTABLE
group by DECISION

Options: ReplyQuote


Subject
Written By
Posted
Re: Calculate sum of distinct Rows
March 24, 2006 10:14AM


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.