Page 109 - SQL
P. 109

select Food,Brand,Total_amount
         from Table
         group by Food,Brand,Total_amount with roll up


          Food    Brand      Total_amount


          Pasta   Brand1     100

          Pasta   Brand2     250


          Pizza   Brand2     300

          Pasta   ALL        350


          Pizza   ALL        300


          ALL     ALL        650


        Read GROUP BY online: https://riptutorial.com/sql/topic/627/group-by




























































        https://riptutorial.com/                                                                               91
   104   105   106   107   108   109   110   111   112   113   114