今日用户发贴的数量排行:
select userid,count(tid) from
flyso_table where convert(char(10),dateandtime,102)=convert(char(10),getdate(),102) group by userid order by count(tid) desc
总发贴的数量排行:
select userid,count(tid) from
flyso_table group by userid order by count(tid) desc