表结构
ID ArticlesID AddTime
1 1 2010-5-1
2 1 2010-5-2
3 3 2010-5-2
4 2 2010-5-2
5 1 2010-5-2
6 2 2010-5-3
7 1 2010-5-3
8 2 2010-5-3
9 1 2010-5-3
我想知道 2010.5 这个月 ArticlesID 等于 1 的统计情况 效果如下
ArticlesID 日期 统计数
1 2010-5-1 1
1 2010-5-2 2
1 2010-5-3 2
SQL语句怎么写？ 在线等！！！
SQL code:
selct ArticlesID,AddTime,统计数=count(1) from tb where ArticlesID=1
group by AddTime
试试
SQL code:
--> 测试数据：[tb]
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([ID] int,[ArticlesID] int,[AddTime] datetime)
insert [tb]
select 1,1,'2010-5-1' union all
select 2,1,'2010-5-2' union all
select 3,3,'2010-5-2' union all
select 4,2,'2010-5-2' union all
select 5,1,'2010-5-2' union all
select 6,2,'2010-5-3' union all
select 7,1,'2010-5-3' union all
select 8,2,'2010-5-3' union all
select 9,1,'2010-5-3'
--------------------------------查询开始------------------------------
select [ArticlesID],[AddTime],count(*
