product_id是多个重复的，需求是每个product_id只取一条，并且id倒序排列。
SQL语句：SQL语句：
SELECT * from (
SELECT * from shop_product_snapshot GROUP BY product_id,id ORDER BY product_id,id DESC
) AS shop_product_snapshot GROUP by product_id ORDER BY `id` DESCSQL分组排序语句
最新推荐文章于 2025-04-07 22:20:05 发布
扫一扫
5431
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
