查询:SELECT *
FROM tb_Customer
WHERE (CustomerName IN
(SELECT customername
FROM tb_Customer
GROUP BY customername
HAVING (COUNT(*)) > 1))
ORDER BY CustomerName
删除:select distinct * into #table_name from table_name
delete from table_name
select * into table_name from #table_name
drop table #table_name
但当字段为text时,不能使用distinct