SQL每日一题(20220609)
select A, B, C, D, E
from (select *, ROW_NUMBER() over (order by A) xh from T1216A) a
right join (select *, ROW_NUMBER() over (order by C) xh from T1216B) b on a.xh = b.xh
SQL每日一题(20220609)
select A, B, C, D, E
from (select *, ROW_NUMBER() over (order by A) xh from T1216A) a
right join (select *, ROW_NUMBER() over (order by C) xh from T1216B) b on a.xh = b.xh