select a.id, a.name,a.location, a.memo , b.cnt from 表 a , (select name,min(id) as id , count(id) as cnt from 表 group by name ) b where a.id = b.id ----------------------- 里面的’表‘这个部分写你的表名，2个都是一样的名字
