要求用一条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)
推荐(0)