ÇóÒ»¾äSQL²éѯÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

±í½á¹¹
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(*