SELECT drivernum,Sum(fuelchrg),Sum(tractorcost),Sum(CashAdvAmt),Sum(cashadvchrg),Sum(totamtdue),Sum(oilcost) ,

Sum(fuelchrg)+Sum(tractorcost)+Sum(CashAdvAmt)+Sum(cashadvchrg)+Sum(totamtdue)+Sum(oilcost) as gTotal

from fuelinvoice group by drivernum

with rollup

ROLLUP generates a result set showing aggregates for a hierarchy of values in the selected columns. VAlue of drivernum will be...