Order By

SQL

select csuserno from csuser order by csuserno asc

select csuserno from csuser order by csuserno desc

XML query API

<query alias="testOrderByAsc" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection>
        <field path="no" /> 
        </projection>
    </projections>
    <sortings>
        <sorting ascending="true">
            <field path="no" /> 
        </sorting>
    </sortings>
</query>

<query alias="testOrderByDesc" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
        <projection>
        <field path="no" /> 
        </projection>
    </projections>
    <sortings>
        <sorting ascending="false">
            <field path="no" /> 
        </sorting>
    </sortings>
</query>