SqlServer中去除重复数据
最近刚接触SQLSERVER，还不是太习惯，最近使用的两个小功能给大家看一下：
删除重复的数据：
select distinct * into #Tmp from tableNamedrop table tableNameselect * into tableName from #Tmpdrop table #Tmp
with tablename() as (select columnname from tablename1);或者select a.* from (select columnname from tablename) a
