Count per date (1 Viewer)

Danny

Registered User.
Local time
Today, 18:55
Joined
Jul 31, 2002
Messages
140
Greetings,

I am trying to find out how many CODE that start with 772 exist for a given day.

In my query I used CODE Like “772*” which gives me part of what I want.
What I’m looking for is the number of CODEs per a given Date.

Please see the attached sample and let me know if you have any questions.

TIA

Regards,
 

Attachments

  • sample.png
    sample.png
    24.9 KB · Views: 35

CJ_London

Super Moderator
Staff member
Local time
Today, 22:55
Joined
Feb 19, 2013
Messages
16,553
use an aggregate query

group by date
count code
where code like 772*

something like

SELECT Date, Count(code) as CountofCode
FROM myTable
WHERE Code like '772*'
GROUP BY Date
 

Danny

Registered User.
Local time
Today, 18:55
Joined
Jul 31, 2002
Messages
140
CJ_London,

Thanks for your solution. It worked nicely!

Regards,
 

Users who are viewing this thread

Top Bottom