Question

mysql怎么根据某一个字段删除重复数据

Answer 1

假设表名为test：select * from (select *, concat(name,code) as __f from test order by date desc) __t group by __f;