SQL查询重复数据

select   *   from   [ProxyServer] 
    where [CompanyID]   in   (select   [CompanyID]   from   [ProxyServer] group   by   [CompanyID] having count(*)>1)