sqlserver删除数据冗余，高手请解释下！thank you

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Release： 2016-06-07 15:34:06

Original

1148 people have browsed it

思路？大哥你几年级的看条件 where ConID = t.ConID and len (GeoNo) len (t.GeoNo) 把 Insert into tb_Table (GeoNo,Title,ConID) values ('01','北京','1000') Insert into tb_Table (GeoNo,Title,ConID) values ('0101','海淀区','1000') Insert into tb

思路？大哥你几年级的

看条件where ConID=t.ConID andlen(GeoNo)>len(t.GeoNo)

把

Insert into tb_Table (GeoNo,Title,ConID) values ('01','北京','1000')
Insert into tb_Table (GeoNo,Title,ConID) values ('0101','海淀区','1000')
Insert into tb_Table (GeoNo,Title,ConID) values ('010101','上地','1000')

弄成

Insert into tb_Table (GeoNo,Title,ConID) values ('010101','上地','1000')

这3条的ConID相同，留下GeoNo长度最大的

Related labels：

sqlserver redundancy delete data explain master

Previous article：MySQL 5.5 分区性能测试之索引使用情况 Next article：学习SQLSERVER2005高可用性数据库镜像的一些心得

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn