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'

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'

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'

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'