SELECT
*
FROM
(
SELECT
ROW_NUMBER () OVER (
PARTITION BY s.SEWAGENAME
ORDER BY
s.MARK_DATE DESC
) rn,
s.*
FROM
SZ_SEWAGE_DATA s
)
WHERE
rn = 1;
---------------------------------------------------------------------------------------------------------------------------------
PARTITION BY 分组列 s.SEWAGENAME
ORDER BY 排序列 s.MARK_DATE
rn 分组后第几条数据