摘要：SELECT * from * where name in (select name from (select name from * group by name having count(name)>1)a) and id not in (select id from(select min(id) 阅读全文