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

怎样找出 姓名相同，会员编号不同的顾客？
姓名 name
会员编号 cli_no

[解决办法]

SQL code

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)