Re: How to count the number of elements for each ID?
Quote
I want to count the number of time that each customer is contacted with. for example id 1 has been contacted twice, id 2 has been contacted 5 times, etc. but based on the database administrator we do not have the contact status column in the database and the one im using is the last date the customer has been contacted with, which would be 1 because it is only the last day. so i guess my query would have been fine if i just put the contact status instead of last_contact_date
Entirely confusing. Please state the requirement in simple English, and show the result of Show Create Table campaign.indiv.
Subject
Written By
Posted
Re: How to count the number of elements for each ID?
April 13, 2014 10:34AM
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.