yql/essentials/tests/sql/suites/pg/select_intersect_all.sql


1
2
3
4
5
6
7
8

--!syntax_pg
select * from (values (1),(1),(1)) a(x)
intersect all
select * from (values (1),(1)) a(x);

select * from (values (1),(1),(1)) a(x)
intersect all
select * from (values (2)) a(x);