Rownum

SQL

SELECT CSUSER01.CSUSERNO AS CSUSERNO01, rowNum AS rowIndex
  FROM CSUSER CSUSER01
 WHERE 1=1

XML query API

<query alias="testRowindex" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection>
            <field path="no"/>
        </projection>
       <projection alias="rowIndex">
            <customValue>
                <expression>rowNum</expression>
            </customValue>
       </projection>
    </projections>
</query>