Having

SQL

SELECT CSUSER01.CITY AS CITY01, COUNT(CSUSER01.CITY) AS cityCount
FROM CSUSER CSUSER01
WHERE 1=1
GROUP BY CSUSER01.CITY
HAVING(COUNT(CSUSER01.CITY) > 5)

XML query API

<query alias="testGroupingFilteringInReportQuery" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection>
            <field path="city"/>
        </projection>
        <projection alias="cityCount">
            <count>
                <field path="city"/>
            </count>
        </projection>
    </projections>
    <groupings>
        <grouping>
            <field path="city"/>
        </grouping>
    </groupings>
    <groupingFilterings>
        <groupingFiltering>
            <greaterThan>
                <count>
                    <field path="city"/>
                </count>
                <integer>5</integer>
            </greaterThan>
        </groupingFiltering>
    </groupingFilterings>
</query>