intersect [distinct|all]

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 3.5.7 - 3.40.0a⚠ 2008R2 - 2022a✓ 8.3+✓ 21c+a⚠ 11gR1 - 19ca✓ 8.0.31+⊘ 5.0 - 8.0.30✓ 10.5+a⚠ 10.3 - 10.4a⊘ 5.1 - 10.2⚠ 9.7 - 11.5.7⚠ 2.0a
  1. Intersect all not supported