高级聚合
---------------
GROUPING SETS.
group by + union all
//查询每个cust的订单数
select count(*) from orders group by cid ;
select count(*) from orders group by orderno ;
//group + union all
select count(*) from orders group by cid union all select count(*) from orders group by orderno ;
//group by :指定按照哪些字段分组,
//grouping sets : 以上字段集如何组合。
select count(*) from orders group by cid,orderno grouping sets(cid,o
---------------
GROUPING SETS.
group by + union all
//查询每个cust的订单数
select count(*) from orders group by cid ;
select count(*) from orders group by orderno ;
//group + union all
select count(*) from orders group by cid union all select count(*) from orders group by orderno ;
//group by :指定按照哪些字段分组,
//grouping sets : 以上字段集如何组合。
select count(*) from orders group by cid,orderno grouping sets(cid,o