Description\n-----------\n\nMINUS is available starting from MariaDB 10.6.1.\n\nMINUS is a synonym for EXCEPT when SQL_MODE=ORACLE is set.\n\n``sql\nCREATE TABLE seqs (i INT);\nINSERT INTO seqs VALUES (1),(2),(2),(3),(3),(4),(5),(6);\n\nSET SQL_MODE='ORACLE';\n\nSELECT i FROM seqs WHERE i <= 3 MINUS SELECT i FROM seqs WHERE i>=3;\n+------+\n| i    |\n+------+\n|    1 |\n|    2 |\n+------+\n``\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data/set-operations/minus