select min(username) username,name,min(idcard) idcard,min(phone) phone from table1 group by name 或者 select max(username) username,name,max(idcard) idcard,max(phone) phone from table1 group by name
第2个回答 2012-05-18
select * from tab where username in (select min(username) from tab group by name);
或者 select * from tab where username in (select max(username) from tab group by name);