Stuff

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