Microsoft
70-433 · Question #123
You have a table named Sales. You are tasked to list products that have been sold to less than ten customers. You need to write a query to achieve the task. Which Transact-SQL statement should you…
The correct answer is B. SELECT ProductID. See the full explanation below for the reasoning.
Question
You have a table named Sales. You are tasked to list products that have been sold to less than ten customers. You need to write a query to achieve the task. Which Transact-SQL statement should you use?
Options
- ASELECT ProductID,
- BSELECT ProductID,
- CSELECT ProductID, CustomerID,
- DSELECT *
How the community answered
(23 responses)- A17% (4)
- B74% (17)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.