Exists / Not Exists

SQL


SELECT CSUSER01.FIRSTNAME AS FIRSTNAME01
  FROM CSUSER CSUSER01
 WHERE (EXISTS
        (SELECT CSUSER02.SALARY AS SALARY01 FROM CSUSER CSUSER02 WHERE 1=1))

SELECT CSUSER01.FIRSTNAME AS FIRSTNAME01
  FROM CSUSER CSUSER01
 WHERE NOT (EXISTS
        (SELECT CSUSER02.SALARY AS SALARY01 FROM CSUSER CSUSER02 WHERE 1=1))

XML query API


<query alias="testExists" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection>
            <field path="firstName"/>
        </projection>
    </projections>
    <filterings>
        <filtering>
            <returnsResults>
                <query alias="subQuery" projectedClass="com.taleo.akirademo.entity.Candidate">
                    <projections>
                        <projection>
                            <field path="salary"/>
                        </projection>
                    </projections>
                </query>
            </returnsResults>
        </filtering>
    </filterings>
</query>

<query alias="testExists" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection>
            <field path="firstName"/>
        </projection>
    </projections>
    <filterings>
        <filtering>
            <not>
                <returnsResults>
                    <query alias="subQuery" projectedClass="com.taleo.akirademo.entity.Candidate">
                        <projections>
                            <projection>
                                <field path="salary"/>
                            </projection>
                        </projections>
                    </query>
                </returnsResults>
            </not>
        </filtering>
    </filterings>
</query>