大家帮忙看看查询问题！急！！！

[myxtlgs]

表数据如下：


A列 B列 C列 D列
1 3 1 2012-01-02
2 2 3 2012-01-03
3 1 4 2012-01-04
4 1 3 2012-01-05
2 3 2 2012-01-07
3 4 2 2012-01-08
4 3 1 2012-01-09


count(*) 我想根据A B C 三列分组 然后想根据D列某段时间内多少个怎么查询？ D列不在分组条件内

[youqi1984]

select A,b,C,count(*) from group by a,b,c where d between startDate and endDate

[bayueguihuaxiang]

select A,b,C,count(*) from 表名
where d between 时间点1 and 时间点2
group by a,b,c

[guo624587253]

select A,b,C,count(*) from where d between startDate and endDate group by a,b,c

[大明湖畔_帅锅]

蹭个分好了 都回复了

[xiedi1209]

1楼不对其它都对
group 后面不能再有where

[jumpheightway]

group by .... having
不就可以搞定你的问题

[Rotel-刘志东]

SELECT A,B,C,COUNT(*)
FROM TB
WHERE D BETWEEN 开始时间 and 结束时间
GROUP BY A,B,C