SqlServer中除去重复数据

SqlServer中去除重复数据
最近刚接触SQLSERVER，还不是太习惯，最近使用的两个小功能给大家看一下：

删除重复的数据：

select distinct * into #Tmp from tableNamedrop table tableNameselect * into tableName from #Tmpdrop table #Tmp

还有一个问题是好像SqlServer不能想oracle哪样，直接拿子查询当做表使用
只能

with tablename() as (select columnname from tablename1);或者select a.* from (select columnname from tablename) a