Question

sql怎么一一对应的查询现在有一个需求，在A表中有姓名和时间两个字段，在B表中也有姓名和时间字段 如下图，现在要这样查询

Answer 1

with t1 as (select 姓名,时间, row_number() over(partition by 姓名 order by 时间) r from A),

t2 as (select 姓名,时间, row_number() over(partition by 姓名 order by 时间) r from B)

select coalesce(t1.姓名,t2.姓名), t1.时间,t2.时间

from t1 full join t2 on t1.姓名=t2.姓名 and t1.r=t2.