except [distinct]

BigQueryDb2 (LUW)H2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 3.5.7 - 3.40.0b⚠ 2008R2 - 2022b✓ 8.3+✓ 21c+a⊘ 11gR1 - 19ca✓ 8.0.31+⊘ 5.0 - 8.0.30✓ 10.5+b⚠ 10.4b✓ 10.3⊘ 5.1 - 10.2⚠ 1.4.200 - 2.1.214b⚠ 9.7 - 11.5.7b⚠ 2.0c
  1. Non-standard alternative: minus
  2. Explicit keyword distinct not supported
  3. Requires the keyword distinct explicitly