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;