|< < 18 > >|

Set operations

intersect


select * from a
intersect
select * from b

X

1

2

3

intersect eliminates duplicates.

|< < 18 > >|