MySQL Forums
Forum List  »  Newbie

Re: How to count the number of elements for each ID?
Posted by: Eesa Sandani
Date: April 10, 2014 01:14PM

Dear Peter,

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

Thanks for the help

Options: ReplyQuote


Subject
Written By
Posted
Re: How to count the number of elements for each ID?
April 10, 2014 01:14PM


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.