Counting the number of records per id in SQL Posted February 29, 2020 I have a huge file with multiple rows per CustomerIDs and Dates. There's a second field called PRODUCT which has various two digits text codes. I want to accomplish two things 1) Convert the date to YYYY-MM 2) for all the combinations of CustomerID and YYYY-MM, I want to count the number of times each PRODUCT occurs. Attached is a sample of 6-7 customers. Thanks Sample for Counting and SQL help.xlsx
Counting the number of records per id
in SQL
Posted
I have a huge file with multiple rows per CustomerIDs and Dates.
There's a second field called PRODUCT which has various two digits text codes.
I want to accomplish two things
1) Convert the date to YYYY-MM
2) for all the combinations of CustomerID and YYYY-MM, I want to count the number of times each PRODUCT occurs.
Attached is a sample of 6-7 customers.
Thanks
Sample for Counting and SQL help.xlsx