谁有时间帮我写个简单的查询?

Question

sqlserver 2000  企业管理器create table visitor
(
id int identity(1,1),
url varchar(50) not null,
ip varchar(20) not null,
address varchar(20) ,
vistime datetime not null default(getDate())
)insert into visitor(url,ip,address) values('index.html','10.0.0.1','地址1')
insert into visitor(url,ip,address) values('index.html','10.0.0.2','地址2')
insert into visitor(url,ip,address) values('login.html','10.0.0.3','地址3')
insert into visitor(url,ip,address) values('login.html','10.0.0.4','地址4')
insert into visitor(url,ip,address) values('login.html','10.0.5.1','地址5')
insert into visitor(url,ip,address) values('reg.html','10.0.6.1','地址6')
insert into visitor(url,ip,address) values('reg.html','10.0.1.1','地址7')
insert into visitor(url,ip,address) values('reg.html','10.0.7.1','地址8')
insert into visitor(url,ip,address) values('reg.html','10.5.0.1','地址9')
insert into visitor(url,ip,address) values('reg.html','10.4.0.1','地址a')
insert into visitor(url,ip,address) values('about.html','10.3.0.1','地址b')
想要查询出每个url 出现的次数如下
_____________________________________
url                  出现次数
_____________________________________
index.html            2
login.html            3
reg.html              5
about.html            1
_____________________________________

Answer 1

select url,count(1) as 出现次数
from tb
group by url

Answer 2

create table visitor
(
id int identity(1,1),
url varchar(50) not null,
ip varchar(20) not null,
address varchar(20) ,
vistime datetime not null default(getDate())
)insert into visitor(url,ip,address) values('index.html','10.0.0.1','地址1')
insert into visitor(url,ip,address) values('index.html','10.0.0.2','地址2')
insert into visitor(url,ip,address) values('login.html','10.0.0.3','地址3')
insert into visitor(url,ip,address) values('login.html','10.0.0.4','地址4')
insert into visitor(url,ip,address) values('login.html','10.0.5.1','地址5')
insert into visitor(url,ip,address) values('reg.html','10.0.6.1','地址6')
insert into visitor(url,ip,address) values('reg.html','10.0.1.1','地址7')
insert into visitor(url,ip,address) values('reg.html','10.0.7.1','地址8')
insert into visitor(url,ip,address) values('reg.html','10.5.0.1','地址9')
insert into visitor(url,ip,address) values('reg.html','10.4.0.1','地址a')
insert into visitor(url,ip,address) values('about.html','10.3.0.1','地址b')
select url,count(1) as 出现次数
from visitor
group by url/**
url                                                出现次数
-------------------------------------------------- -----------
about.html                                         1
index.html                                         2
login.html                                         3
reg.html                                           5(4 行受影响)
**/

Answer 3

select url,count(url) as 出现次数 from visitor
group by url/*
url                                                出现次数        
-------------------------------------------------- ----------- 
about.html                                         1
index.html                                         2
login.html                                         3
reg.html                                           5（所影响的行数为 4 行）*/drop table visitor

Answer 4

select url,count(1) as 出现次数 from visitor group by url

Answer 5

select url,count(1) as 出现次数 from tb group by url

Answer 6

select url,count(1) as 出现次数 from visitor group by url

Answer 7

create table visitor
(
id int identity(1,1),
url varchar(50) not null,
ip varchar(20) not null,
address varchar(20) ,
vistime datetime not null default(getDate())
)insert into visitor(url,ip,address) values('index.html','10.0.0.1','地址1')
insert into visitor(url,ip,address) values('index.html','10.0.0.2','地址2')
insert into visitor(url,ip,address) values('login.html','10.0.0.3','地址3')
insert into visitor(url,ip,address) values('login.html','10.0.0.4','地址4')
insert into visitor(url,ip,address) values('login.html','10.0.5.1','地址5')
insert into visitor(url,ip,address) values('reg.html','10.0.6.1','地址6')
insert into visitor(url,ip,address) values('reg.html','10.0.1.1','地址7')
insert into visitor(url,ip,address) values('reg.html','10.0.7.1','地址8')
insert into visitor(url,ip,address) values('reg.html','10.5.0.1','地址9')
insert into visitor(url,ip,address) values('reg.html','10.4.0.1','地址a')
insert into visitor(url,ip,address) values('about.html','10.3.0.1','地址b')select url , count(1) 出现次数  from visitor group by urldrop table visitor/*
url                                                出现次数        
-------------------------------------------------- ----------- 
about.html                                         1
index.html                                         2
login.html                                         3
reg.html                                           5（所影响的行数为 4 行）
*/