- sqLiteDatabase
= mdb.dbHelper.getReadableDatabase(); - Cursor
listCursor = sqLiteDatabase.rawQuery("SELECT _id,address,body,type,date,ac from MySms a , (SELECT max(date) maxd,count(address) ac from MySms Group By address) b where a.date = b.maxd order by date desc",null); - startManagingCursor(listCursor);
sqLiteDatabase = mdb.dbHelper.getReadableDatabase(); Cursor listCursor = sqLiteDatabase.rawQuery("SELECT _id,address,body,type,date,ac from MySms a , (SELECT max(date) maxd,count(address) ac from MySms Group By address) b where a.date = b.maxd order by date desc",null); startManagingCursor(listCursor);