select_intersect_all.sql 191 B

12345678
  1. --!syntax_pg
  2. select * from (values (1),(1),(1)) a(x)
  3. intersect all
  4. select * from (values (1),(1)) a(x);
  5. select * from (values (1),(1),(1)) a(x)
  6. intersect all
  7. select * from (values (2)) a(x);