17,377
社区成员
发帖
与我相关
我的任务
分享
select id,编号,工资,身份证,日期戳,电话,手机
from
(select a.id,a.编号,a.工资,a.身份证,a.日期戳,b.电话,b.手机
row_number()over(partition by a.身份证 order by a.日期戳 desc,b.日期戳 desc) rn
from a,b
where a.身份证 = b.身份证) t
where t.rn = 1
;
select aa.ID,aa.编号,aa.姓名,aa.工资,aa.身份证,aa.日期戳,bb.电话,bb.手机 from
(select * from A where (身份证, 日期戳) in (select 身份证, max(日期戳) 日期戳 from A group by 身份证)) aa
left join
(select * from B where (身份证, 日期戳) in (select 身份证, max(日期戳) 日期戳 from A group by 身份证)) bb
on aa.身份证=bb.身份证
select * from
(select * from A where (身份证, 日期戳) in (select 身份证, max(日期戳) 日期戳 from A group by 身份证)) aa
left join
(select * from B where (身份证, 日期戳) in (select 身份证, max(日期戳) 日期戳 from A group by 身份证)) bb
on aa.身份证=bb.身份证