TOP 5

select u.hundnr
     , h.hundnamn
     , sum(u.poang)
     , (select sum(utr.poang)
          from utst_resultat utr
         where utr.hundnr = u.hundnr) as total
      , count(*) as antal
  from utst_resultat u
inner
  join hund h
    on u.hundnr = h.hundnr
 where u.poang
    in (select top 5 ur.poang
          from utst_resultat ur
         where ur.hundnr = u.hundnr
        order
            by ur.poang desc)
group
    by u.hundnr
     , h.hundnamn

:)