yql/essentials/tests/sql/suites/intersect/intersect_mix.sql


1
2
3
4
5
6
7

(SELECT * FROM (VALUES (1), (2), (3), (4)) AS t (x))
INTERSECT
(SELECT * FROM (VALUES (2), (3), (4)) AS t (x))
INTERSECT
(SELECT * FROM (VALUES (1), (2), (3)) AS t (x))
INTERSECT
(SELECT * FROM (VALUES (1), (3), (4)) AS t (x));