1DROP TABLE IF EXISTS t1; 2DROP TABLE IF EXISTS t2; 3CREATE TABLE t1 (c1 INT, c2 CHAR(100)); 4INSERT INTO t1 VALUES (null,null); 5INSERT INTO t1 VALUES (1,''); 6INSERT INTO t1 VALUES (2,'abcde'); 7INSERT INTO t1 VALUES (100,'abcdefghij'); 8CREATE TABLE t2 (c1 INT); 9INSERT INTO t2 VALUES (null); 10INSERT INTO t2 VALUES (2); 11INSERT INTO t2 VALUES (100); 12SELECT c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2); 13c1 14SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2); 15c1 16SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2); 17c1 18SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2); 19c1 20SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2); 21c1 22DROP TABLE t1; 23DROP TABLE t2; 24CREATE TABLE t1 (c1 INT, c2 VARCHAR(100)); 25INSERT INTO t1 VALUES (null,null); 26INSERT INTO t1 VALUES (1,''); 27INSERT INTO t1 VALUES (2,'abcde'); 28INSERT INTO t1 VALUES (100,'abcdefghij'); 29CREATE TABLE t2 (c1 INT); 30INSERT INTO t2 VALUES (null); 31INSERT INTO t2 VALUES (2); 32INSERT INTO t2 VALUES (100); 33SELECT c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2); 34c1 35SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2); 36c1 37SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2); 38c1 39SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2); 40c1 41SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2); 42c1 43DROP TABLE t1; 44DROP TABLE t2; 45CREATE TABLE t1 (c1 INT, c2 BINARY(100)); 46INSERT INTO t1 VALUES (null,null); 47INSERT INTO t1 VALUES (1,''); 48INSERT INTO t1 VALUES (2,'abcde'); 49INSERT INTO t1 VALUES (100,'abcdefghij'); 50CREATE TABLE t2 (c1 INT); 51INSERT INTO t2 VALUES (null); 52INSERT INTO t2 VALUES (2); 53INSERT INTO t2 VALUES (100); 54SELECT c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2); 55c1 56SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2); 57c1 58SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2); 59c1 60SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2); 61c1 62SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2); 63c1 64DROP TABLE t1; 65DROP TABLE t2; 66CREATE TABLE t1 (c1 INT, c2 VARBINARY(100)); 67INSERT INTO t1 VALUES (null,null); 68INSERT INTO t1 VALUES (1,''); 69INSERT INTO t1 VALUES (2,'abcde'); 70INSERT INTO t1 VALUES (100,'abcdefghij'); 71CREATE TABLE t2 (c1 INT); 72INSERT INTO t2 VALUES (null); 73INSERT INTO t2 VALUES (2); 74INSERT INTO t2 VALUES (100); 75SELECT c1 FROM t1 WHERE c1 > ALL (SELECT c1 FROM t2); 76c1 77SELECT c1 FROM t1 WHERE c1 >= ALL (SELECT c1 FROM t2); 78c1 79SELECT c1 FROM t1 WHERE c1 = ALL (SELECT c1 FROM t2); 80c1 81SELECT c1 FROM t1 WHERE c1 <= ALL (SELECT c1 FROM t2); 82c1 83SELECT c1 FROM t1 WHERE c1 <> ALL (SELECT c1 FROM t2); 84c1 85DROP TABLE t1; 86DROP TABLE t2; 87