34,875
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
愉快的登山者 2002-07-25
- 打赏
- 举报
select distinct * into #temptable from tablename
delete tablename
go
insert into tablename from select * from #temptable
go
delete tablename
go
insert into tablename from select * from #temptable
go
愉快的登山者 2002-07-25
- 打赏
- 举报
select distinct * into #temptable from tablename
delete tablename
go
insert into tablename from select * from #temptable
go
delete tablename
go
insert into tablename from select * from #temptable
go
OpenVMS 2002-07-25
- 打赏
- 举报
前面太多这样的帖子,可惜网络太慢
假使表中只有name,num2字段
delete a
from #t1 a
where exists(select name,num from #t1 where name=a.name and num=a.num group by name,num having count(*)>1)
假使表中只有name,num2字段
delete a
from #t1 a
where exists(select name,num from #t1 where name=a.name and num=a.num group by name,num having count(*)>1)
Yang_ 2002-07-25
- 打赏
- 举报
select distinct * into temptable from tablename
go
truncate table tablename
go
insert tablename
select * from temptable
go
drop table temptable
go
go
truncate table tablename
go
insert tablename
select * from temptable
go
drop table temptable
go
