Oracle数据库按字段分组排序取最近一条数据

Oracle数据库按字段分组排序取最近一条数据

SELECT
	* 
FROM
	( SELECT id row_number ( ) over ( PARTITION BY 分类字段 ORDER BY 排序字段 DESC ) AS row_number FROM 表名 ) temp 
WHERE
	row_number = '1'

路漫漫