PostgreSQL
两张表关联,关联的表有多条数据,查询结果只要求关联的表展示最新的数据。
如下图:关联的数据有两条,结果只需要查询红框的数据即可
查询代码如下:
SELECT er.id,eh_memo.memo
FROM event_release AS er
LEFT JOIN (
SELECT eh.release_id,
(
SELECT
UNNEST (
ARRAY_AGG (
eh.memo
ORDER BY eh.create_time DESC
)
)
LIMIT 1
) memo
FROM event_handle AS eh
GROUP BY eh.release_id
) eh_memo ON eh_memo.release_id = er. ID
WHERE eh_memo.release_id = '8a8a8a9977f63e0d01782032488d0157'
ORDER BY er.create_time
运行结果如下: