sql关联表查询只关联某个字段最新的一条记录 这里用的是ROW_NUMBER() OVER()函数 select b.date,b.notice_no,a.* from tableA a, (select t.*,row_number() over(partition by notice_no(表字段) order by date desc nulls last) rn from tableB t where t.notice_id = 'CBDLYWBAHZ' and t.state = '12') b where a.ent_id= b.engaged_busi and b.rn = 1