Mine

select GRUP, CLIENT, COD_CLIENT, NUME, SUMA   from TBL where GRUP in ( select GRUP, sum(SUMA)                    from TBL                   group by GRUP                  order by sum(SUMA) desc                  limit 10  ) order by GRUP,CLIENT;