怎样找出 姓名相同，会员编号不同的顾客？解决方法

select *from tb twhere 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)