合计列
select decode(grouping(billing_day),1,'合计',billing_day),decode(grouping(area_code),1,'小计',area_code),count(* )
from rep_commission_a
where billing_day >=20041201
and billing_day <=20041231
group by rollup(billing_day,area_code)
select decode(grouping(billing_day),1,'合计',billing_day),decode(grouping(area_code),1,'小计',area_code),count(* )
from rep_commission_a
where billing_day >=20041201
and billing_day <=20041231
group by rollup(billing_day,area_code)
浙公网安备 33010602011771号