怎样在一个表中找到某两个字段都相同的记录

[fp2003]

怎样在一个表中找到某两个字段都相同的记录，比如表中有name age 两个字段，其中有多个name=张三，age=23的记录（张三只是举个例子，意思是这样的记录），怎样把它们找出来
注：mysql

[liangxusy]

select name age from 表 where name='张三' and age=23

或者 模糊点的用like select name age from 表 where name like '%张三%' and age like '%23%'

[itzhiren]

select * from table where name='张三' and age=23

[fp2003]

-->张三只是举个例子，意思是这样的记录

[fp2003]

楼上的再帮想想

[hsj20041004]

select name,age,count(*) as 次数 from tb group by name,age having count(*)>1

[wangdehao]

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

[hsj20041004]

or:
select name,age from tb a where (select count(*) from tb where name=a.name and age=a.age)>1

[jiang130]

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

[fp2003]

问题已解决，谢谢大家