数据库表中去除多个字段完全重复的数据，保留唯一

select distinct * into #t from tb
truncate table tb
insert into tb select * from #t

一条sql语句效率比较低，建临时表效率比较高些

create table mayong as (select distinct* from sms.vehicle);
delete from sms.vehicle ;
insert into sms.vehicle select * from mayong;