intersect [distinct]

BigQueryDb2 (LUW)H2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 3.5.7 - 3.41.0a⚠ 2008R2 - 2022a✓ 8.3+✓ 21c+a⚠ 11gR1 - 19ca✓ 8.0.31+⊘ 5.0 - 8.0.30✓ 10.5+a⚠ 10.4a✓ 10.3⊘ 5.1 - 10.2⚠ 1.4.192 - 2.1.214a⚠ 9.7 - 11.5.8a⚠ 2.0b
  1. Explicit keyword distinct not supported
  2. Requires the keyword distinct explicitly