下面使用with cube 结果如何解释? 和 rollup 区别? 哪个常用 ?
USE pubs SELECT pub_id,type, total = avg(price) FROM titles GROUP BY type ,pub_id
with cube
pub_id type total
------ ------------ ---------------------
0736 business 2.9900
1389 business 17.3100
NULL business 13.7300
0877 mod_cook 11.4900
NULL mod_cook 11.4900
1389 popular_comp 21.4750
NULL popular_comp 21.4750
0736 psychology 11.4825
0877 psychology 21.5900
NULL psychology 13.5040
0877 trad_cook 15.9633
NULL trad_cook 15.9633
0877 UNDECIDED NULL
NULL UNDECIDED NULL
NULL NULL 14.7662
0736 NULL 9.7840
0877 NULL 15.4100
1389 NULL 18.9760