求一sql语句

[Satan0629]

有一个table（table1）
包含有id name 等列
怎样可以得到所有name相同而id不同的记录的结果？
请大家帮忙看看

[jinjazz]

select a.* from table1 a ,table1 b
where a.id=b.id and a.name<>b.name

[didoleo]

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

[liricn]

select a.* from table1 a ,table1 b
where a.id<>b.id and a.name=b.name

[leiwenpin]

SELECT A.* FROM TABLE1 A INNER JOIN (SELECT NAME,ID FROM TABLE1 GROUP BY NAME,ID HAVING COUNT(*)=1) B ON A.ID=B.ID AND A.NAME=B.NAME INNER JOIN (SELECT NAME FROM TABLLE GROUP BY NAME HAVING COUNT(*)>1) C ON A.NAME=C.NAME

[aoran98]

select a.* from tablel a,tablel b
where a.name=b.name and a.id<> b.id