sql 数据库怎样查询某一列下相同的值

Question

举例说有张表studentInfo
字段有 id name age
记录是 1 张三 25
2 李四 26
3 张三 24
4 王五 23
5 赵七 24
现在同个班级里面同名同姓的人会有的！
我怎样写 sql 语句 可以查询到
id name
1 张三
3 张三

求高手帮忙！

Answer 1

select id,name from studentInfo
where name in (select name from studentInfo group by name having count(name)>1)

Answer 2

select id, name
from studentInfo t1
where name in (select name from studentInfo group by name having count(name)>1)