Group By

SQL

SELECT APPLICATION01.CANDIDATENO AS candidate,
       COUNT(APPLICATION01.CANDIDATENO) AS appCount
FROM APPLICATION APPLICATION01
WHERE 1=1
GROUP BY APPLICATION01.CANDIDATENO

XML query API

<query alias="testReportQueryWithGrouping" projectedClass="com.taleo.akirademo.entity.BaseApplication">
    <projections>
        <projection alias="candidate">
            <field path="candidate"/>
        </projection>
        <projection alias="appCount">
            <count>
                <field path="candidate"/>
            </count>
        </projection>
    </projections>
    <groupings>
        <grouping>
            <field path="candidate"/>
        </grouping>
    </groupings>
</query>