I have an issue which I'm trying to solve. We contact customers a number of times during an application. We don't count how many times we call them. I want to get an SQL statement which this by date.

Attached is an image of how the column should appear, with the inserted column in yellow. Would be amazing to see this statement!

thanks Matt

enter image description here

  • Where is the call information stored? Are your call records stored inside of a separate DE? Jun 7 '18 at 13:15
  • Two images provided seem to be identical. Am I missing something?
    – Ranga
    Jun 7 '18 at 13:16
  • @Gortonington all records are in the same table Jun 7 '18 at 22:53
  • @Ranga, sorry i put in the image twice accidently! Jun 7 '18 at 22:54
  • 1
    You should be able to do something like: select count(id), Email From ObjectName Group By Email
    – Ranga
    Jun 8 '18 at 8:18

You should be able to do something like:

[select count(Id), Email From ObjectName Group By Email]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.