Oracle数据库按字段分组排序取最近一条数据 SELECT * FROM ( SELECT id row_number ( ) over ( PARTITION BY 分类字段 ORDER BY 排序字段 DESC ) AS row_number FROM 表名 ) temp WHERE row_number = '1' 路漫漫