1】sql去重复
select * from View where SfzId in (select SfzId from View group by SfzId having count(1)<2)
2】sql替换字符串
--将2222.222中的.替换 为 1 replace('2222.222','.','1')
2】sql 找到指定的字符/字符串位置
SELECT PATINDEX('%.%','2222.111.221') --输出结果 5 因为第一个.的下表是5
select * from View where SfzId in (select SfzId from View group by SfzId having count(1)<2)
--将2222.222中的.替换 为 1 replace('2222.222','.','1')
SELECT PATINDEX('%.%','2222.111.221') --输出结果 5 因为第一个.的下表是5
转载于:https://www.cnblogs.com/1439107348s/p/10727994.html