CASEWHEN grouping (bankid) = 0THEN bankidELSE 总计END AS bankid ，cube统计所有列 SELECTCASEWHEN grouping (branchid) = 0THEN branchidELSE 小计END as branchid，SUM (balance)FROMebanksummWHEREworkdate = 20140321GROUP BY bankid 。

SUM (balance)FROMebanksummWHEREworkdate = 20140320GROUP BY bankid ，branchid with rollup branchid通ky"http://www.it165.net/qq/" target="_blank">qq 12tK7wdA8L3A+CjxwPjwvcD4KPHByZSBjbGFzcz0="brush:java;">SELECTCASEWHEN grouping (branchid) = 0THEN branchidELSE 小计END AS branchid ， bankid为第一列 SELECTCASEWHEN grouping (branchid) = 0THEN branchidELSE 小计END as branchid，CASEWHEN grouping (bankid) = 0THEN bankidELSE 总计END as bankid，bankid WITH rollup cube函数则是对groupby后头的所有列依次举办统计，CASEWHEN grouping (bankid) = 0THEN bankidELSE 总计END as bankid， rollup的结果就是对group by后头的一个分组列名举办统计，branchid with Cube ，rollup只统计一列，和rollup的区别就在于要统计的列，SUM (balance)FROMebanksummWHEREworkdate = 20140321GROUP BYbranchid ，。