mysql中的cube和rollup_group by、rollup、cube的用法以及区别

在此使用oracle，oracle 中的用法为 group by [rollup|cube]( colomn),sql server中的用法为group by colomn with [rollup|cube]

首先要弄明白rollup 和cube，就要知道group by的用法，group by 为对列进行分组，只展现分组统计的值，而rollup 为分层次展现，cube为展现列中所有层次，听我娓娓道来。

1、搭建场地

首先建立一个group_by 表,列值分别为购买者名称，购买物品的大类，购买物品的小类，物品以及价格，

用户购买了一些3C以及衣物

1 create tablegroup_by (2 o_name varchar2(20),3 o_class varchar2(20),4 o_item varchar2(20),5 o_object varchar2(20),6 o_price int

7 )8

9 insert into group_by values('springy','3C','phone','huawei',4000);10 insert into group_by values('springy','3C','phone','xiaomi',3000);11 insert into group_by values('springy','3C','computer','mac',10000);12 insert into group_by values('springy','3C','phone','thinkpad',8000);13 insert into group_by values('springy','3C','phone','huawei',4000);14 insert into group_by values('springy','clothes','shoes','adidas',300);15 insert into group_by values('springy','clothes','shoes','lining',400);16 insert into group_by values('springy','clothes','pants','jackjones',500);17 insert into group_by values('stephenson','clothes','shoes','adivon',200);18 insert into group_by values('stephenson','clothes','shoes','nike',300);19 insert into group_by values('stephenson','clothes','skirt'