ALL

Overview

Presence in all returned rows.

See also: SQL Operators in 10.6 ES, in 10.5 ES, and in 10.4 ES

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

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES