Sub-query in SQLQuery

edit

Here is a simple code example that is using both IN and ORDER BY:

SQLQuery<MyClass> query = new SQLQuery<MyClass> (MyClass.class , "num IN (1,2,3) ORDER BY num");        
MyClass ret [] = gigapace.readMultiple(query, Integer.MAX_VALUE);

The space class:

public class MyClass {
    Integer num;
    String str;
    Integer id;
    @SpaceIndex (type=SpaceIndexType.BASIC)
    public Integer getNum() {
        return num;
    }
    public void setNum(Integer num) {
        this.num = num;
    }
    @SpaceIndex (type=SpaceIndexType.BASIC)
    public String getStr() {
        return str;
    }
    public void setStr(String str) {
        this.str = str;
    }
    @SpaceId (autoGenerate = false)
    @SpaceRouting
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
}