SQL查询重复数据

查询重复的数据并只保留一条

select Grid1_Name,count(*) over(partition by Grid1_Name order by Grid1_Name) m into #Table from Craft
select distinct Grid1_Name from #Table where m>1
drop table #Table

或者

select distinct Grid1_Name from Craft where Grid1_Name in (select Grid1_Name from Craft group by Grid1_Name having count(*)>1)

或者

select distinct Grid1_Name from (select Grid1_Name from Craft group by Grid1_Name having count(*)>1)t1

SQL语句 - 嵌套查询http://www.cnblogs.com/kissdodog/archive/2013/06/03/3116284.html