>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
>

>
>So, in the result, I get all the keys that I need for the most recent 10 threads. However, based on those keys, I would now like to include a column for the count. Thread.NoThread have several occurences in the table. So, the result would include a column for the count having a value from 1 to x.

Do you mean

select Temp.NoThread, count(*) over (partition by Temp.NoThread) as CountThreads
 from (SELECT Top 10 NoThread FROM Thread ORDER BY Numero DESC) Temp