mysql 获得最新的数据并且去除重复

商品表 product

字段 id、 product_code、product_name、create_date

select * from (select *,product_code as code from product order by create_date desc) t group by code;