Count

SQL

SELECT COUNT((CSUSER01.CSUSERNO)) AS keyCount FROM CSUSER CSUSER01

XML query API

<query alias="testCount" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
         <projection alias="keyCount">
             <count>
                 <field path="no"/>
             </count>
         </projection>
    </projections>
</query>