Sort Data with more than one operand

Android
1

Hello, I have database table for storing offers, I want to sort data by “created” and another column in my table called"isSpecialOffer"
which have either 0 or 1,
“1” : means special offer
“0” : means not special offer
i want the special offers to be shown first regardless of “Created” then the other offers to be sorted by Created.

2

Hello Mohammed,

So what column do you want it to be sorted by? You mentioned by created, is it the only sorting criteria?

Mark

3

the other column is a custom column in my table
i want to sort with my" custom column "and "created "

4

i solved it this way :
ArrayList order = new ArrayList();
order.add(“mycolumn DESC”);
order.add(“created DESC”);
queryBuilder.setSortBy(order);
thanks mark