sqlスクリプト配線重複データ

sql server重複レコードのクエリー

--sql     
select * from     WHERE        in ( 
    select        from     
         group by        
       having count(      )>1
    )

 
sql serverフィールドクエリー

--sql server     exists
select *  FROM  [dbo].[hc_TemplateInfo] as a
where exists (select 1 from (select 
            treeid,[WorkShopType],treeName
            FROM  [dbo].[hc_TemplateInfo]  group by treeid,[WorkShopType],treeName having count(*) > 1) AS b 
            WHERE a.treeid=b.treeid and a.[WorkShopType]=b.[WorkShopType] AND A.treeName=B.treeName 
            )

--orcal      in
SELECT * from [dbo].[hc_TemplateInfo] as a
where (a.treeid,a.[WorkShopType],a.treeName)
in(select treeid,WorkShopType,[treeName] from [dbo].[hc_TemplateInfo] 
group by treeid,WorkShopType,[treeName]
having count(*)>1)