ALL
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Operators for MariaDB Enterprise Server
Topics on this page:
Overview
Presence in all returned rows.
EXAMPLES
CREATE TABLE all_example (
description VARCHAR(20),
example INT
);
CREATE TABLE all_example_values (
val INT
);
INSERT INTO all_example VALUES
('Everything', 42),
('Dalmations', 101),
('Agent', 99),
('B. Doz.', 13),
('CPU', 64);
INSERT INTO all_example_values VALUES
(42), (64), (99);
SELECT * FROM all_example
WHERE example != ALL (SELECT val FROM all_example_values);
+-------------+---------+
| description | example |
+-------------+---------+
| Dalmations | 101 |
| B. Doz. | 13 |
+-------------+---------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.