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, , , , , , ]
Submit