34,590
社区成员
发帖
与我相关
我的任务
分享
--> 测试数据:@tb
declare @tb table([col] varchar(12))
insert @tb
select '10.11.23.21' union all
select '10.11.56.87' union all
select '10.346.78.90' union all
select '20.11.337.55'
select distinct LEFT(col,charindex('.',col,charindex('.',col)+1)-1) as col from @tb
/*
col
------------
10.11
10.346
20.11
(3 行受影响)
*/
--> 测试数据:@tb
declare @tb table([col] varchar(12))
insert @tb
select '10.11.23.21' union all
select '10.11.56.87' union all
select '10.346.78.90' union all
select '20.11.337.55'
select parsename(col,4)+'.'+parsename(col,3) from @tb group by parsename(col,4)+'.'+parsename(col,3)
/*
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
10.11
10.346
20.11
(3 行受影响)
*/