投稿统计前十名

select top 10 a.userid,a.username,totalNum from ks_user a,(select inputer,count(*) as totalnum from ks_article where verific=1 group by inputer)b where a.username=b.inputer order by b.totalnum desc

循环体:

[loop=10]

<li>{$Field(username,Text,0,...,0,)}(稿件:{$Field(totalNum,Num,0,2)})</li>

[/loop]

能不能加一个什么函数 只显示当前月份的投稿统计呢？

完整的是不是这样？

select top 10 a.userid,a.username,totalNum from ks_user a,(select inputer,count(*) as totalnum from ks_article where  verific=1 AND month(getdate())=DatePart("m",adddate) group by inputer)b where a.username=b.inputer order by b.totalnum desc

提示getdate 函数未定义

sql数据库用getdate  access数据库用now