Question

在mysql中查询某一段时间内的数据 报错where 后面提示语法错误

select count(discountid)count3,discountid from reverts1 r group by r.discountid where replytime between '2007-12-02 11:25:37' and now()

Answer 1

where加到group by的前面才对,group by后面的条件用having

select count(discountid) as count3,discountid from reverts1 where replytime between '2007-12-02 11:25:37' and now() group by discountid

Answer 2

你的语法错误喽，一般sql语句的顺序是： where / group by ...havaing /order by