--楼上没有当日的判断 --楼主只要指定一天的还是所有天的? --不知道dateandtime该字段的类型,假设为datetime型 --所有的: select username, convert(varchar(12),dateandtime,112) as 日期, 数量=count(1) from bbs group by username, convert(varchar(12),dateandtime,112) order by count(1) desc --一天的: declare @date datetime set @date=getdate()--指定日期 select username, 数量=count(1) where datediff(d,dateandtime,@date)=0 from bbs group by username order by count(1) desc
这个能行,可以对n天的用户做帖数多少的排序 select username,count(username) as Icount,convert(varchar(10),dateandtime) from t_t group by convert(varchar(10),dateandtime),username order by convert(varchar(10),dateandtime) ,count(username) desc 给分啊,还帮你建立表来测试过了!!!
--楼主只要指定一天的还是所有天的?
--不知道dateandtime该字段的类型,假设为datetime型
--所有的:
select username, convert(varchar(12),dateandtime,112) as 日期, 数量=count(1)
from bbs group by username, convert(varchar(12),dateandtime,112)
order by count(1) desc
--一天的:
declare @date datetime
set @date=getdate()--指定日期
select username, 数量=count(1)
where datediff(d,dateandtime,@date)=0
from bbs group by username
order by count(1) desc
select username,count(username) as Icount,convert(varchar(10),dateandtime)
from t_t group by convert(varchar(10),dateandtime),username
order by convert(varchar(10),dateandtime) ,count(username) desc
给分啊,还帮你建立表来测试过了!!!
不能看出每天的发帖排序,!