Notifications
Clear all
Topic starter
A developer wants to populate a data extension with the date of the most recent click for each subscriber .
Which query would accomplish this?
- A . SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC
B. SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
C. SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey
D. SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1
Suggested Answer: C
Posted : 10/02/2023 4:24 am