ContentResolver().query的分组查询

来源:互联网 发布:首席数据官实战 编辑:程序博客网 时间:2024/05/02 00:28

  query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder);

方法中没有group by的参数,这个方法毕竟是别人封装的sql语句,于是我把group by放在了selection里。结果报错了。

  在网上找了一下,原来是 拼接的不对。and后面加一个查询语句。方式如下

String[] projection = newString[] {
  "_id","thread_id","address",
  "person","body","date"};
Cursor cursor = context.getContentResolver().query(SMS_PROVIDER,
  projection,"0=0) group by (thread_id",null,"date desc");



1 0
原创粉丝点击