4KastorForum论坛SQL

来源:互联网 发布:美萍软件好用么 编辑:程序博客网 时间:2024/04/28 02:24

48小时(按点击)
select top 20 * from [4k_forum_threads] where  datediff(hour,datecreated,getdate())<=48  order by hits desc

48小时(按回复)
select top 20 * from [4k_forum_threads] where  datediff(hour,datecreated,getdate())<=4
order by resplies desc

一周
datediff(day,datecreated,getdate())<=7

一月

datediff(day,datecreated,getdate())<=30

原创粉丝点击