Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

Salesforce Certified Marketing Cloud Engagement Developer MCE-Dev-201 Question # 44 Topic 5 Discussion

Salesforce Certified Marketing Cloud Engagement Developer MCE-Dev-201 Question # 44 Topic 5 Discussion

MCE-Dev-201 Exam Topic 5 Question 44 Discussion:
Question #: 44
Topic #: 5

A new record is appendedto the Orders data extension each time a customer makes a purchase. Which SQL statement would select a unique list of subscribers who have made multiple purchases?


A.

SELECT TOP 1 SubscriberKey FROM Orders


B.

SELECT DISTINCT SubscriberKey FROM Orders


C.

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey


D.

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


Get Premium MCE-Dev-201 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.