A developer wants to populate a data extension with the date of the most recent click for each subscriber. Which query would accomplish this?

Question

MARCIA SHEILA PELAEZ GONZALEZ · Accepted Answer

SELECT c.SubscriberKey, MAX(c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

MARCIA SHEILA PELAEZ GONZALEZ · Answer

SELECT TOP 1 c.SubscriberKey, c.eventDate FROM _Click c ORDER BY c.eventDate DESC

MARCIA SHEILA PELAEZ GONZALEZ · Answer

SELECT c.SubscriberKey, MIN (c.eventDate) AS eventDate FROM _Click c GROUP BY c.SubscriberKey

MARCIA SHEILA PELAEZ GONZALEZ · Answer

SELECT c.SubscriberKey, c.eventDate FROM _Click c WHERE c.IsUnique = 1

List of questions