MySQL Forums
Forum List  »  Newbie

Re: How to count the number of elements for each ID?
Posted by: Peter Brawley
Date: April 13, 2014 10:34AM

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.

Options: ReplyQuote


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.