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?
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
Answer:
C
User Votes:
A
50%
B
50%
C 1 votes
50%
D 2 votes
50%
Discussions
0/ 1000
carloscuartasm
1 year, 8 months ago
D. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
Buonve
4 months, 4 weeks ago
Correct Answer is D
Want to join our community?
Please log in or signup in order to use this feature
D. SELECT SubscriberKey FROM Orders GROUP BY SubscriberKey HAVING COUNT(*)>1
Correct Answer is D