SQL查询重复数据 

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

　　

posted @ 2016-08-01 10:47  会弹猫的吉他  阅读(395)  评论(0)  编辑  收藏  举报