sql 重复数据排行

select top 10 postuser,count(*) num from LxTel_Topic where boardid>0 and IsDel=0 and postsh=0 and datediff("d",PostTime,’2010-12-6‘)=0 group by postuser order by num desc