1,将重复的记录记入temp1表: select [标志字段id],count(*) into temp1 from [表名] group by [标志字段id] having count(*)>12、将不重复的记录记入temp1表: insert temp1 select [标志字段id],count(*) from [表名] group by [标志字段id] having count(*)=13、作一个包含所有不重复记录的表: select * into temp2 from [表名] where 标志字段id in(select 标志字段id from temp1)4、删除重复表: delete [表名]5、恢复表: insert [表名] select * from temp26、删除临时表: drop table temp1 drop table temp2
truncate table b
insert into b select * from #
drop table #
From Table
go
having count(*)>2)
insert into b select * from #
drop table #
select [标志字段id],count(*) into temp1 from [表名]
group by [标志字段id]
having count(*)>12、将不重复的记录记入temp1表:
insert temp1
select [标志字段id],count(*) from [表名]
group by [标志字段id]
having count(*)=13、作一个包含所有不重复记录的表:
select * into temp2 from [表名]
where 标志字段id in(select 标志字段id from temp1)4、删除重复表:
delete [表名]5、恢复表:
insert [表名]
select * from temp26、删除临时表:
drop table temp1
drop table temp2
from tab
where id not in
(select min(id) from tab
group by 学号)