SELECT
*
FROM
( SELECT id row_number ( ) over ( PARTITION BY 分类字段 ORDER BY 排序字段 DESC ) AS row_number FROM 表名 ) temp
WHERE
row_number = '1'
————————————————
版权声明:本文为CSDN博主「Darmk」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/zhangFG77/article/details/125787777