如两条记录不是完全重复,利用如下语句 select xx,xx,xx from table where id in (select max(id) from table group by [需要去重的字段])