I'm trying to pull the data from
purchaseddate is (day - 1). if the customer only purchased a single product in a day, include him in results. If a customer purchases more than 1 product in a day, exclude that customer.
I'm not very good with SQL, Can someone pls help me with this. Below query is working however I'm not able to exclude those customers who purchased more than 1 product in a day.
Here is an example of my use case: -On February 1st, Mr.Xyz purchased Product1. So productpurchased updated to 1. -On the same day, Mr.Xyz purchased Product2, so productpurchased updated to 2 with same subcriberID. -Now, for 1st February, there are two records with the same subscriberID and purchaseddate. For first record productpurchased = 1 and for second record it is 2.
As there are 2 records for Mr. Xyz, I would like to exclude him from the query results.
My sql Query :-
subscriberID, phonenumber, productpurchased, purchaseddate, productcode
productcode in (203, 211, 502)
purchaseddate > dateadd(d,-1,getdate())
productpurchased <= '1'