I am using sqlite in my application with activeAndroid lib .
i want to get all the rows from a table, where the value of a certain column(long type) is within a range i specified.
in SQL it can be achieved by :
SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;
my current method is :
List<Report> reports = new Select()
.from(Report.class)
.execute();
which brings all of the rows in the table
Aucun commentaire:
Enregistrer un commentaire