select acct, grouping(acct), sum(amount) from pjtran group by acct with rollup select acct, grouping(acct), sum(amount) from pjtran group by acct with cube