select *
from tb
where rootid in
(
select top 10 rootid
(
select rootid,max(messageid) as flast
from tb
group by rootid
) a
order by flast desc
)