编程论坛
注册
登录
编程论坛
→
SQL Server论坛
几万条数据,但有重复的,怎样用SQL语句筛选出来?
lingchen
发布于 2007-12-02 14:22, 1250 次点击
如题,请高手指教!
1 回复
#2
purana
2007-12-02 14:41
select distinct * into # from tb
truncate table tb
insert into tb select * from #
drop table #
1