Between

SQL

SELECT CSUSER01.CSUSERNO AS CSUSERNO01 
  FROM CSUSER CSUSER01 
 WHERE (CSUSER01.CSUSERNO BETWEEN 1 AND 10))

XML query API

<filtering> 
    <between 
        <field path="no"/> 
        <integer>1</integer> 
        <integer>10</integer> 
    </between> 
</filtering>