A new record is appended to 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?

Question

A new record is appended to 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?

Said Jabri · Accepted Answer

SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey

Said Jabri · Answer

SELECT TOP 1 SubscriberKey FROM Orders

Said Jabri · Answer

SELECT DISTINCT SubscriberKey FROM Orders

Said Jabri · Answer

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

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 138 - Certified Marketing Cloud Developer discussion

Suggested answer: C

0 comments