急求一个SQL语句 在线等

[linzi779]

比如说一个列的内容 http://seek.3721.com/index.htm?coagent=dh ，我只取http://seek.3721.com 用什么函数

[tianhxk]

还有其他特征吗？？

[xeqtr1982]

declare @t varchar(50)
set @t='http://seek.3721.com/index.htm?coagent=dh'
select left(@t,charindex('/',replace(@t,'http://',''))+7)

[xeqtr1982]

declare @t varchar(50)
set @t='http://seek.3721.com/index.htm?coagent=dh'
select left(@t,charindex('/',replace(@t,'//',''))+2)

[linzi779]

比如说表
aa count
http://seek.3721.com/index.htm? 3

http://seek.3721.com/index.htmdfdfsg 10


http://www.baidu.com/index.htmdfddfdffsg 2
http://www.baidu.com/index.ht 5

...................
我要让他的结果是
http://seek.3721.com 总数
http://www.baidu.com 总数
................................

[xeqtr1982]

declare @t table(aa varchar(50),[count] int)
insert into @t select 'http://seek.3721.com/index.htm?',3
union all select 'http://seek.3721.com/index.htmdfdfsg',10
union all select 'http://www.baidu.com/index.htmdfddfdffsg',2
union all select 'http://www.baidu.com/index.ht',5

select left(aa,charindex('/',replace(aa,'//',''))+2) as aa,sum([count]) as 总数 from @t group by left(aa,charindex('/',replace(aa,'//',''))+2)