Salesforce Developers Marketing-Cloud-Developer Question # 15 Topic 2 Discussion

To select a unique list of subscribers who have made multiple purchases, the developer should use the following SQL statement:

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*) > 1

This query groups the records by SubscriberKey and selects only those groups where the count of records is greater than one, indicating multiple purchases.

References:

SQL GROUP BY Statement

SQL HAVING Clause