需求:取出每种checkunit中,sampledate时间为最新的一条的数据(日期并列相同会取其一)
表:test
sql:
SELECT
temp.*
FROM
(
SELECT *, Row_Number () OVER (
partition BY checkunit
ORDER BY
sampledate DESC
) AS rank
FROM
test
) temp
WHERE
rank = 1
查询结果:
需求:取出每种checkunit中,sampledate时间为最新的一条的数据(日期并列相同会取其一)
表:test
sql:
SELECT
temp.*
FROM
(
SELECT *, Row_Number () OVER (
partition BY checkunit
ORDER BY
sampledate DESC
) AS rank
FROM
test
) temp
WHERE
rank = 1
查询结果: