SELECT Tmp.dyeri, Tmp.Sayid

FROM

(SELECT TOP 10 tPersonel.dyeri, Count(tPersonel.id) AS Sayid

FROM tPersonel

GROUP BY tPersonel.dyeri

HAVING (((tPersonel.dyeri) Is Not Null))

ORDER BY Count(tPersonel.id) DESC ) as Tmp ORDER BY Tmp.dyeri;