DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
SELECT item name, color, clothes SIZE, SUM(quantity)FROM salesGROUP BY rollup(item name, color, clothes SIZE);How many grouping is possible in this rollup?
|
|
8
|
|
|
4
|
|
|
2
|
|
|
1
|
Explanation:
Detailed explanation-1: -SELECT item name, color, clothes SIZE, SUM(quantity) FROM sales GROUP BY rollup(item name, color, clothes SIZE); How many grouping is possible in this rollup? Explanation: (item name, color, clothes size), (item name, color), (item name), () . 10.
There is 1 question to complete.