except [distinct]

BigQueryDb2 (LUW)DerbyH2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200820102012201420162018202020222024⚠ 3.5.7 - 3.50.0b⚠ 2008R2 - 2022b✓ 8.3 - 18✓ 21c - 23.26.0a⊘ 11gR1 - 19ca✓ 8.0.31 - 9.5.0⊘ 5.0 - 8.0.30✓ 10.5 - 12.0.2b⚠ 10.4b✓ 10.3⊘ 5.1 - 10.2⚠ 1.4.192 - 2.4.240b✓ 10.16.1.1 - 10.17.1.0⚠ 9.7 - 12.1.2b⚠ 2.0c
  1. Non-standard alternative: minus
  2. Explicit keyword distinct not supported
  3. Requires the keyword distinct explicitly