oracle的rollup操作--按照小组进行分组，同时求总计(二)
d d on (tt.card_no = d.card_no)
left join (select distinct (card_type) as card_type, name, mediatype
from t_cardkind_para) l on (d.card_type = l.card_type)
group by rollup(tt.inst_date, nvl(c.username, tt.opr_id),
nvl(l.name, d.card_type),tt.bat_mchnt_id)