select *
from tb t
where exists (select 1 from tb where name = t.name and id <> t.id)
order by name

------解决方案--------------------
SQL code
select * from tb t where exists (select 1 from tb where name=t.name and cli_no<>t.cli_no)

------解决方案--------------------
探讨


SQL code

select *
from tb t
where exists (select 1 from tb where name = t.name and id <> t.id)
order by name


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

  select  *  from  tab1  a 
where  exists (select  1  from  tab1  where name=a.name  and cli_no<>a.cli_no)