一个sql查询的问题

[zhourongbiao]

数据表test主要结构：
datatime--- datetime
data --- double
如何写sql查询从2005－7－9到2005－8－9之间datatime相同的所有数据？如何分别统计各个datatime对应的记录数？
兼问在何处能找到sql语言提高型的教程或论坛？我对sql的使用知道基础但不知道怎样提高

[zhimianzhao]

如何写sql查询从2005－7－9到2005－8－9之间datatime相同的所有数据？

SELECT * FROM test b WHERE datatime where datatime between '2005-07-09' and '2005-08-09'
GROUP by datatime HAVING COUNT(*)>1


如何分别统计各个datatime对应的记录数？
select count(*) from test where datatime between '2005-07-09' and '2005-08-09' group by datatime

[mathematician]

如何分别统计各个datatime对应的记录数？
select count(*) from test where datatime>'2005-7-9' and datatime<'2005-8-9' group by datatime;

[mathematician]

如何写sql查询从2005－7－9到2005－8－9之间datatime相同的所有数据？

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;

[cy_angel]

学习