VB 删除数据库中的重复信息

假设field1 , field2 为 你要查找的字段
id 为主健

delete from table x,
(
select field1 , field2 ,min(id) as id
from table1
group by field1 , field2
)y
where x.field1 = y.field1 and x.field2 = y.field2 and x.id <> y.id

并将序号重新按顺序排列 , 只有用游标了。。。

declare @old_id int
declare @new_id int
--1.init

set @new_id = 1
--2.open cursor
declare cursor cslist for
select id from table1

open csstatus

--3.logic
fetch next from csstatus into @old_id
@while @@fetch_status = 0
begin
update table1 set id = @new_id where id =@old_id
set @new_id = @new_id + 1
fetch next from csstatus into @old_id
end

--2>.release column list
close cslist
deallocate cslist

select dist(某些字段相同的字段名,只能一个),fields from 表名 order by 字段名 group by 字段名(dist里面的那个字段)