Question

ACCESS数据库的SQL查询两个时间段函数怎么写

Answer 1

select * from 表 where 日期 between 开始日期 and 结束日期

追问

我是统计文章作者对应的文章数量，并做降序排列。
select Author,count(*) from KS_Article where adddate between 2013-06-18 and 2014-01-01 group by Author order by count(*) desc
这样写的后，提示author这个字段不是合计函数的特定表达式,Author是文章作者的字段

Answer 2

select * from(select Author,count(*) as num from KS_Article where adddate between 2013-06-18 and 2014-01-01 group by Author)a order by a.num desc

追问

不对哦，点下一步说FROM子语句错误

追答

select Author,count(*) as num from KS_Article where adddate between 2013-06-18 and 2014-01-01 group by Author

这句报错吗？