select name,age,count(*) as 次数 from tb group by name,age having count(*)>1
select name,age from table group by name,age having count(*)>1
or: select name,age from tb a where (select count(*) from tb where name=a.name and age=a.age)>1
select * from table1 where name in(select name from table1 group by name,age having count(*)>1) and age in(select age from table1 group by name,age having count(*)>1) order by name,age
select name,age,count(*) as 次数 from tb group by name,age having count(*)>1
select name,age from tb a where (select count(*) from tb where name=a.name and age=a.age)>1