P Pre Langsql Cssfilehk1styleselect Item Name Color Clothes #420

</p> <pre><code class="language-sql">Select item name, color, clothes size, sum(quantity) from sales group by rollup(item name, color, clothes size);</code></pre> <p>How many grouping is possible in this rollup?

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - OLAP - Quiz No.1.

Select item name, color, clothes size, sum(quantity) from sales group by rollup(item name, color, clothes size);