select min(id)id,name,min(zp)zp from 表A group by name 按name分类,各取最小的id和name或者select * from 表A where id in (select min(id) from 表A group by name)按name分类取出各最小id,再作为条件取表行
