Operator
| Description
| Example
|
---|---|---|
EXISTS
| Returns true if at least one row meets the specified condition in the subquery. NOT EXISTS is also a valid construct.
| EXISTS(C_MT_PERSON_DETAILS, MATCH_PATH_COMPONENT.C_MT_PERSON_DETAILS|BIRTH_CITY = 'NEW YORK')
|
COUNT
| Returns the number of rows that meet the specified condition.
| COUNT(C_MT_ADDRESS, MATCH_PATH_COMPONENT.C_MT_PARTY_ADDRESS_REL|ADDRESS_TYPE = 'Shipping') |