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