论坛如何获取一周内的发帖量

[Mr_D]

论坛如何获取一周内的前10个用户的发帖量

[慕容玄明]

10个用户是指最早发帖的10个用户还是发帖最多的10个用户？

[threenewbee]

select count(*) as topiccount, first(userid) from topictable where date between 2012-03-01 and 2012-03-31 group by userid order by topiccount

[骑着蜗牛去爬山]

先按照一周内的发帖量排序，取前十个就行

[那一抹嫣红]

select top 10 userid from table where timecreate between time1 and time2 group by id order by COUNT(0)desc

[那一抹嫣红]

group by userid

[Mr_D]

[Quote=引用 2 楼 的回复:]

SQL code
select count(*) as topiccount, first(userid) from topictable where date between 2012-03-01 and 2012-03-31 group by userid order by topiccount
[/Quote]

这个方法我想过，但是我实现不了动态的获取，你这个是写死了的，我想实现根据当前日期来选择这周发帖量最多的前10个用户

[Mr_D]

[Quote=引用 1 楼 的回复:]

10个用户是指最早发帖的10个用户还是发帖最多的10个用户？
[/Quote]

发帖量

[Mr_D]

[Quote=引用 4 楼 的回复:]

select top 10 userid from table where timecreate between time1 and time2 group by id order by COUNT(0)desc
[/Quote]

我知道是在time1 和time2之间选取，但是我实现不了这个两个时间的绑定

[wuhailin010]

select top 10 from table where datediff(week,endtime,getdate())=0

查询一周内的数据，可以动态给值