# E061-09: Subqueries in comparison predicate


statement ok
CREATE TABLE TABLE_E061_09_01_01 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_09_01_01 WHERE A < ( SELECT 1 )

statement ok
CREATE TABLE TABLE_E061_09_01_02 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_09_01_02 WHERE A <= ( SELECT 1 )

statement ok
CREATE TABLE TABLE_E061_09_01_03 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_09_01_03 WHERE A <> ( SELECT 1 )

statement ok
CREATE TABLE TABLE_E061_09_01_04 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_09_01_04 WHERE A = ( SELECT 1 )

statement ok
CREATE TABLE TABLE_E061_09_01_05 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_09_01_05 WHERE A > ( SELECT 1 )

statement ok
CREATE TABLE TABLE_E061_09_01_06 ( ID INT PRIMARY KEY, A INT );

query I
SELECT A FROM TABLE_E061_09_01_06 WHERE A >= ( SELECT 1 )
