SELECT
*
FROM
TABLE1 A
LEFT JOIN (
SELECT
*
FROM
(
SELECT
T .*, ROW_NUMBER () OVER (
PARTITION BY T .PROBE_ID
ORDER BY
T .create_time DESC
) rn
FROM
TABLE2 T
) c
WHERE
rn = 1
) b ON A . ID = b.probe_id
oracle sql语句left join右表取最新的一条数据
最新推荐文章于 2024-07-30 17:55:15 发布