Microsoft
70-433 · Question #86
You have a table named ProductCounts that contains 1000 products as well as the number of units that have been sold for each product. You need to write a query that displays the top 5% of products…
The correct answer is D. WITH Percentages AS (. See the full explanation below for the reasoning.
Question
You have a table named ProductCounts that contains 1000 products as well as the number of units that have been sold for each product. You need to write a query that displays the top 5% of products that have been sold most frequently. Which Transact-SQL code segments should you use?
Options
- AWITH Percentages AS (
- BWITH Percentages AS (
- CWITH Percentages AS (
- DWITH Percentages AS (
How the community answered
(39 responses)- A5% (2)
- B13% (5)
- C8% (3)
- D74% (29)
Community Discussion
No community discussion yet for this question.