SELECT * FROM test b WHERE datatime in (
SELECT datatime FROM test a WHERE DATE(datatime)>'2005-07-09'
and DATE(datatime)<'2005-08-01' GROUP by datatime HAVING COUNT(*)>1);
如何分别统计各个datatime对应的记录数?
select count(*) from test where DATE(datatime)>'2005-07-09' and DATE(datatime)<'2005-08-09' group by datatime;