相对于group,partition by 能够查询出来除了分组以外的其他字段,但是没有过滤,加上row_number()函数就可以过滤出来最新的一条
SELECT
*
FROM
(
SELECT
SID,
field_group,
field_desc,
ROW_NUMBER () OVER (
PARTITION BY field_group
ORDER BY field_desc DESC
) AS rn
FROM
table t
)
WHERE
rn = 1
转载地址:
https://blog.csdn.net/txqd1989/article/details/72729785