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_lixihaving count(s_name)>1)