问题描述:
平邮调价JAVA,平邮利润率记录错误
SELECT t1.*
FROM `t_surface_adjustprice` t1
INNER JOIN (
SELECT msku, MAX(id) as max_id
FROM `t_surface_adjustprice`
WHERE msku IN (
'M13337GNEIID022','6Y05XCU07AX1MP3203021','Q1211FF02BDJ3J3','2560T7VL037Q00MHJY8BLCO','Z4E5I05UYSIC1GYS6OB1702Q',
'I031AT0802M','K443GJ05OQ15XN9Y','T127085GFP'
)
GROUP BY msku
) t2 ON t1.msku = t2.msku AND t1.id = t2.max_id
ORDER BY t1.id DESC
