select [Dict_District].*,Dict_City.DName from [Dict_District]
left join dbo.Dict_City on Dict_City.DID=[Dict_District].CityID
where [Dict_District].dname in(
SELECT
[DName]
FROM [zhuoyou0623].[dbo].[Dict_District]
group by dname
having COUNT(1)>1
)
order by [Dict_District].dname
验证是否有重复数据