select *  from tb where destaddr in (select destaddr from tb group by destaddr having count(1)>1)

------解决方案--------------------
select destaddr from tb group by destaddr having count(*)>1

------解决方案--------------------

探讨


引用:
SQL code

select *  from tb exists (select destadd  from tb group by destadd having count(1)>1)



我执行有语法错误！exists 报红线，我的数据库是sqlserver2000的