Quantified Predicate

Description

A quantified predicate compares a value or values with a collection of values.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

SELECT COLA FROM TBLAB WHERE COLA ^= SOME(SELECT COLX FROM TBLXY);
SELECT COLA FROM TBLAB WHERE COLA ^< SOME(SELECT COLX FROM TBLXY);
SELECT COLA FROM TBLAB WHERE COLA !< SOME(SELECT COLX FROM TBLXY);
SELECT COLA FROM TBLAB WHERE COLA ^> SOME(SELECT COLX FROM TBLXY);
SELECT COLA FROM TBLAB WHERE COLA !> SOME(SELECT COLX FROM TBLXY);

Snowflake

Code 1

SELECT COLA FROM TBLAB WHERE COLA <> SOME(SELECT COLX FROM TBLXY);
SELECT COLA FROM TBLAB WHERE COLA >= SOME(SELECT COLX FROM TBLXY);
SELECT COLA FROM TBLAB WHERE COLA >= SOME(SELECT COLX FROM TBLXY);
SELECT COLA FROM TBLAB WHERE COLA <= SOME(SELECT COLX FROM TBLXY);
SELECT COLA FROM TBLAB WHERE COLA <= SOME(SELECT COLX FROM TBLXY);

Note that the transformation for the operators are the same from this page.