update tableA
set status = latest_data.status
from (select distinct on (idA)
       idA, status, date
      from   tableB
      -- helps to retrieve the latest update for each unique idA
      order by idA, date desc) latest_data
where latest_data.idA = tableA.id;

• • DISTINCT ON**子句参见文档。

有关详细信息，请参阅demo。

根据IdA按日期升序排列表b，然后选择行号1更新表a。
Row_number（）超过（排序依据...）
tableb是第二个表，tablen是第一个表

update tablen t1 set status = t2.status
from 
(select id, IDA, status from (
select *,
row_number ()over(partition by IDA order by daten desc) rnk
from tableb) x 
  where rnk = 1)t2 where t1.id = t2.idA;

此子句用于获取最后更新

select id, IDA, status from (
select *,
row_number ()over(partition by IDA order by daten desc) rnk
from tableb) x 
  where rnk = 1