按照今日用户发贴的数量将用户排序select * from user a left join (select userid,count(*)as num from tiezi where convert(varchar(10),dateandtime,120)=convert(varchar(10),getdate(),120)group by userid)b on a.userid=b.userid order by b.num 按照所有发贴的数量排序
select * from user a left join (select userid,count(*)as num from tiezi group by userid)b on a.userid=b.userid order by b.num
select * from user a left join (select userid,count(*)as num from tiezi group by userid)b on a.userid=b.userid order by b.num
select userid,count(tid) from tiezi where convert(char(10),dateandtime,102)=convert(char(10),getdate(),102) group by userid order by count(tid) desc总发贴的数量排行:
select userid,count(tid) from tiezi group by userid order by count(tid) desc