注册 登录
编程论坛 SQL Server论坛

几万条数据,但有重复的,怎样用SQL语句筛选出来?

lingchen 发布于 2007-12-02 14:22, 1250 次点击
如题,请高手指教!
1 回复
#2
purana2007-12-02 14:41
select distinct * into # from tb
truncate table tb
insert into tb select * from #
drop table #
1