|< < 19 > >|

Set operations

intersect all


select * from a intersect all select * from b

X
1
2
3
3
  • intersect all preserves duplicates.
  • The number of occurrences of an element is the minimum count from each table.

|< < 19 > >|