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'