07 2010 档案
要求用一条sql语句删除表内的重复数据
摘要:1.某字段重复create table testB (id int identity(1,1),name varchar(50))insert into testB(name)select 'aa'union allselect 'aa'union allselect 'bb'union allselect 'cc'union allselect 'cc'--select * from testb... 阅读全文
posted @ 2010-07-21 10:37 huyg 阅读(615) 评论(2) 推荐(0)