34,590
社区成员
发帖
与我相关
我的任务
分享
select count(*) from tb group by left(url,16)
create table tb(col varchar(50))
insert into tb values('http://75ke.com/')
insert into tb values('http://www.75ke.com/')
insert into tb values('http://www.75ke.com/?err')
go
select url = 'http://' + left(substring(col,8,len(col)) , charindex('/',substring(col,8,len(col)))-1) + '/' , cnt = count(1) from tb
group by 'http://' + left(substring(col,8,len(col)) , charindex('/',substring(col,8,len(col)))-1) + '/'
drop table tb
/*
url cnt
---------------------------------------------------------- -----------
http://75ke.com/ 1
http://www.75ke.com/ 2
(所影响的行数为 2 行)
*/
select 'http://' + left(substring(col,8,len(col)) , charindex('/',substring(col,8,len(col)))-1) + '/' , count(1) from tb
group by 'http://' + left(substring(col,8,len(col)) , charindex('/',substring(col,8,len(col)))-1) + '/'