数据库学习--INTERSECT ALL (SQL Server)

SELECT NAME from A

INTERSECT

SELECT NAME from B

表A

表B

结果:

with intersect_all as
(
    select row_number() over(partition by NAME order by (select 0)) as rowNum,
        NAME from A
    intersect
    select row_number() over(partition by NAME order by (select 0)) as rowNum,
        NAME from b
)
select NAME from intersect_all

参考:点击打开链接