Question

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

表格如图一 查询结果如图二 数据库为mysql





Answer 1

如果只是要图2的效果，排序就可以了

select * from table order by name;

如果要查每个相同的名字分别有多少个

select name,count(*) from table group by name;

Answer 2

select id,name,age from tablename where name in (select name from tablename group by(name) having count(*)>1)

Answer 3

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次以上的名字