怎样筛选出重复的纪录

[lu64]

我想找出table表中所有name字段相同，age不同的所有纪录。SQL查询语句该如何写？谢谢！

[LouisXIV]

--try

select distinct a.*
from tablename a
inner join tablename b
on a.name=b.name
and a.age!=b.age

[lxzm1001]

select name from table group by name having count(*)>1

[lu64]

select name from table group by name having count(*)>1
这样只能搜索出name的重复纪录，不管age是否相同。

[fcuandy]

select * from table a
INNER JOIN
(select name from table group by name having count(*)>1)b
ON a.Name=b.Name

[fcuandy]

select a.* from table a
INNER JOIN
(select name from table group by name having count(*)>1)b
ON a.Name=b.Name

[junmail]

select a.name,a.age from test a
inner join (select name from test group by name having count(*)>1) b
on a.name=b.name
group by a.name,a.age having count(*)<=1

[十一月猪]

select distinct name , age from tab
or
select name , age from tab
group by name ,age

[love_AC]

junmail(浪子) 的答案正确