Ver originalselect max(total), day(idfechafactura) from(Select sum(totalproducto) as total, idfechafactura from tblfacturagroup by idfechafactura) as t1 group by day(idfechafactura)