>>SELECT Temp.NoThread, (SELECT COUNT(*) FROM Thread WHERE NoThread = Temp.NoThread) >>FROM >>(SELECT Top 10 NoThread FROM Thread ORDER BY Numero DESC) Temp >>