intersect [distinct]

BigQueryDb2 (LUW)DerbyH2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200720092011201320152017201920212023⚠ 3.5.7 - 3.50.0a⚠ 2008R2 - 2022a✓ 8.3 - 17✓ 21c - 23.9a⚠ 11gR1 - 19ca✓ 8.0.31 - 9.3.0⊘ 5.0 - 8.0.30✓ 10.5 - 12.0.2a⚠ 10.4a✓ 10.3⊘ 5.1 - 10.2⚠ 1.4.192 - 2.3.232a✓ 10.16.1.1 - 10.17.1.0⚠ 9.7 - 12.1.2a⚠ 2.0b
  1. Explicit keyword distinct not supported
  2. Requires the keyword distinct explicitly