I wanted to know if MAX(Eventdate) works in SFMC as its not working for me. I'm trying to only extract customer who have opened the email and only want to pull the records with most recent time/date as the extract contains dupes.
The query I'm using is below. I only want to pull all customers who has opened their email yesterday and with the email name below
SELECT Max(EventDate) as Eventdate, IsUnique, SubscriberKey, SubscriberID FROM _open o JOIN _Job j ON j.jobid = o.jobid WHERE eventdate >= DATEADD(dd,-1,getdate()) AND EmailName = 'EW01 welcome email'