删除数据库中相同学号的学生（全部）

[liuminkuaile]

我想删除学生信息表中的所有学号相同的学生记录！不知如何写SQL语句！

[woyaofengle]

delete from table where exists (select studentID from tabel group by 1 having count(*)>1 )

[goodboycwy]

insert into new_table select distinct * from old_table
然后把new_table 重新命名为 old_table

[txlicenhe]

Delete yourTable where studentID in (Select studentID from yourTable group by studentID having count(*) > 1)

[liuminkuaile]

Delete yourTable where studentID in (Select studentID from yourTable group by studentID having count(*) > 1)
好象不行呀！

[pengdali]

Delete 表 where exists (Select studentID from 表 tem group by 所有列 having sum(1)>1 and tem.所有列=所有列)

[pengdali]

删除重复，留下一条:

select distinct * into #temp from 表
truncate table 表
select * into 表 from #temp
drop table #temp

[zclxyh]

select distinct * into #temp from 表
truncate table 表
select * into 表 from #temp
drop table #temp