All pages
Powered by GitBook
1 of 1

MINUS

MINUS is available starting from 10.6.1.

MINUS is a synonym for EXCEPT when SQL_MODE=ORACLE is set.

CREATE TABLE seqs (i INT);
INSERT INTO seqs VALUES (1),(2),(2),(3),(3),(4),(5),(6);

SET SQL_MODE='ORACLE';

SELECT i FROM seqs WHERE i <= 3 MINUS SELECT i FROM seqs WHERE i>=3;
+------+
| i    |
+------+
|    1 |
|    2 |
+------+

This page is licensed: CC BY-SA / Gnu FDL