T-SQL 集锦

alter table SubscribeList add  id int identity(1,1)
select max(id) as id into #t from SubscribeList group by mail
delete from SubscribeList where id not in (select id from #t)
drop table #t
alter table SubscribeList drop column id 

删除表中重复字段,保留一个.