SELECT Temp.NoThread, (SELECT COUNT(*) FROM Thread WHERE NoThread = Temp.NoThread) FROM (SELECT Top 10 NoThread FROM Thread ORDER BY Numero DESC) Temp>I would like to retrieve the count from a derived SQL. I am not sure about the best approach to use. This is the SQL I have:
>SELECT Temp.NoThread >FROM >(SELECT Top 10 NoThread FROM Thread ORDER BY Numero DESC) Temp >>