Distinct

SQL

select distinct currency from csuser

XML query API

<query alias="subQuery" preventDuplicates="true" projectedClass="com.taleo.akirademo.entity.Candidate">
    <projections>
         <projection alias="currency">             
             <field path="currency"/>             
         </projection>
    </projections>
</query>