SqlServer中除去重复数据

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