本月和全年的查询

[jnzsk]

"select upuser,count(filename) from upwz group by upuser order by count(filename) desc"

上面的语句，如何查本月和全年的记录，时间字段为:datetime

[jia_guijun]

select upuser,count(filename) from upwz 
 where datediff(mm,datetime,getdate())=0 --本月
group by upuser order by count(filename) desc


select upuser,count(filename) from upwz 
 where datediff(year,datetime,getdate())=0 --今年
group by upuser order by count(filename) desc

[百年树人]

where datediff(mm,时间字段,getdate())=0 --本月

where datediff(yy,时间字段,getdate())=0 --本年

[jwdream2008]

select upuser,count(filename) from upwz where datediff(mm,date,getdate())=0
 group by upuser order by count(filename) desc
select upuser,count(filename) from upwz where datediff(yyyy,date,getdate())=0
 group by upuser order by count(filename) desc

[jwdream2008]

本月：select upuser,count(filename) from upwz where datediff(mm,date,getdate())=0
 group by upuser order by count(filename) desc
全年：
select upuser,count(filename) from upwz where datediff(yyyy,date,getdate())=0
 group by upuser order by count(filename) desc

[jnzsk]

我用的是access数据库

[jwdream2008]

Access 代码：

本月：select upuser,count(filename) from upwz where datediff('mm',date,Now())=0
 group by upuser order by count(filename) desc
全年：
select upuser,count(filename) from upwz where datediff('yyyy',date,Now())=0
 group by upuser order by count(filename) desc

[jnzsk]

[Quote=引用 6 楼 jwdream2008 的回复:]
Access 代码：

SQL code本月：select upuser,count(filename) from upwz where datediff('mm',date,Now())=0
group by upuser order by count(filename) desc
全年：
select upuser,count(filename) from upwz where datediff('yyyy',date,Now())=0
group by upuser order by count(filename) desc
[/Quote]
上面的语句不正确，系统提示：
Microsoft JET Database Engine 错误 '80040e14'
无效的过程调用