Select Distinct * from materielhead paoluo(一天到晚游泳的鱼) 真是快啊如果想把重复的数据删除可以 select distinct * into #t from materielhead delete from materielhead insert into materielhead select * from #t drop table #t
以上是查询,如果是要将重复的删除。Select Distinct * Into #T from materielheadTruncate Table materielheadInsert Into materielhead Select * from #TDrop Table #T
以上是查询,如果是要将重复的删除。Select Distinct * Into #T from materielheadTruncate Table materielheadInsert Into materielhead Select * from #TDrop Table #T
paoluo(一天到晚游泳的鱼) 真是快啊如果想把重复的数据删除可以
select distinct * into #t from materielhead
delete from materielhead
insert into materielhead select * from #t
drop table #t