mysql查询一个表中name相同的记录 ？

Question

mysql查询一个表中name相同的记录 

Answer 1

select name,id,age from table_name where name in (select name from table_name group by name having count(*)>1) order by name;
select name from table_name group by name having count(*)>1用于列出所有 出现2次或2次以上的名字

Answer 2

select * from 表 where n_id in
(select s_name from 表
group by s_name,n_money,s_zhipiao,s_date,s_lixi
having count(s_name)>1)