android - 使用 sqlite.query() 函数的 GROUP BY 查询

Question

我有 sqlite 工作和测试查询。

我只是想把它转换成sqlitedatabase.query();函数

select distinct id, date ,sum(goal) from goal where id=0 and date = 'Sep 15, 2015' group by id, date;

如何实现？

Answer 1

尝试以下。

String table = "goal";
String[] columns = new String[] { "distinct id", "date", "sum(goal)" };
String selection = "id=? and date=?";
String[] arguments = new String[] { "0", "Sep 15, 2015" };
String groupBy = "id, date";
String having = null;
String orderBy = null;
db.query(table, columns, selection, arguments, groupBy, having, orderBy);

参见 doc